Thursday, November 21

Menu Bar

Header And Footer Bottom Set In Excel

Header And Footer Bottom Set In Excel

Insert Menu, Menu Bar, Page Layout
Header And Footer Introduction: You have choice to add headers or footers at the top or bottom of a printed worksheet in Excel. You can create your own header and footer, or you can use many built-in headers and footers available in excel. As example, you can create a footer that has page numbers, no of pages ,date, sheet name, Time, Picture path of your file etc.. Note:- Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. 1. How To Insert Header And Footer In Excel: Click The Worksheet Where You Want To Add Or Change Headers Or Footers.Click On The Insert Tab > In The Text Group > Click Header & Footer.Type Your Custom Text In The Header Or Footer Text Box If You Want To Add Or Edit An Existing Header Or Footer, Click On ...
Filter In Excel

Filter In Excel

Home Menu, Lookup & Reference
DEFINITION:- Filter is a great way to select the data of your choice by applying to a particular database. Filter has many option available for a different criteria and with the help of those option we can extract the data according to our choice. Filter can be applicable on more then one columns. For more details please follow the step below. Open Excel File.First Select The Database To Apply The Filer.Go To Home Tab.Click On Sort & Filet On The Right Side Under Editing Command Tab.Once Clicked You Will See Drop Down List.Click On Filter Option.Once Clicked The Filer Will Get Applied On Database.Go To The Particular Column For Which You Want The Filter To Look in.Select The Criteria And Apply The Filter.Once Applied Only The Selected Criteria Item Will Be Displayed.For More Deta...
Goto Special In Excel

Goto Special In Excel

Home Menu, Menu Bar
DEFINITION:- The Go To Special Function In Excel Allows You To Quickly Select All Cells That Meet Certain Criteria, Such As Cells Containing: Comments, Constants, Formulas (Numbers, Text, Logical, Errors), Blank Cells, Objects Etc. Blank Will Select The Blank Cell Only.Current Region Will Select From The Active Cell To Last Row. makes Sure You Don't Have A Blank Cell Otherwise It Will Consider Above The Blank Row As Last Row.Current Array Will Select The Active Range Belongs To.Object Will Select Any Object Available In A Range. Ex:- ShapesLast Cell Will Select The Last Used Cell In A Worksheet. Even If You Delete The Data From Cell.Visible Cells Will Select Only Visible Cell If Any Filter Is Applied Or Even Any Row Or Columns Are Available.Conditional Formatting Will Select The Forma...
Go To Method In Excel

Go To Method In Excel

Home Menu, Menu Bar
Definition:- Go To Feature Is Use To Move The Cell Cursor To A New Cell In The Worksheet. You Can Also Use This Feature To Select A Range Of Cells. There Are Three Ways To Access “Go To” Press The F5Press Ctrl+GHome Tab – Find & Select – Choose “Go To…” To Move The Cell Cursor To A Particular Cell, Enter The Cell Address In The “Reference” Text Box And Click Ok. You Can Also Select A Range Of Cells By Taking These Steps: Select The First Cell Of The Range.Type The Cell Address Of The Last Cell In The Range In The “Reference” Text Box.Hold Down The Shift Key As You Click Ok Or Press Enter To Close The Go To Dialog Box.
How To Use Find And Replace In Excel

How To Use Find And Replace In Excel

Home Menu, Menu Bar
FIND : Click CTRL + F One Find And Replace Dialog Box Will PopupSelect Database Or Range Or Directly Type The Text Or Number To Find Out OR Follow The Below Step For Another Method.Click The Home TabGo To The Editing Group Command Tab.Click On Find & Select ButtonA Dropdown Menu Will Appear. Click On Find. Steps :- In The Dialog Box Input The Text Or Number In “Find What” To Find The Data Within The Worksheet Or Database For And Then - Click “Find Next” MULTIPLE SEARCH : If You Want To Find Out How Many Times A Particular Word Or Phrase Has Been Used Or Found In Your Database Or Worksheet , Click “Find All” In The Dialog Box Will Populate The Match Row Where The Query Data Is Available. FIND & REPLACE : Select Database Or RangeClick The Home Tab...
How To Insert Shapes In Excel

How To Insert Shapes In Excel

Insert Menu, Menu Bar
DEFINITION:- You Can Add Shapes, Such As Boxes, Circles, Arrows Etc.. To Your Worksheet As Shown In Image Below. Steps:- On The Insert Tab, Click Shapes.Click The Shape You Want To Insert And Then Click Anywhere In The Workspace In The Worksheet And Then Drag The Shape To The Exact Place .There Are Lots Of Shapes Available In Excel And It Also Useful To Assign A Sub Procedure (Macro) By Creating A Beautify Button Type Object.
How To Insert Online Picture In Excel

How To Insert Online Picture In Excel

Insert Menu, Menu Bar
DEFINITION:- Online Picture Option Is Use To Download An Images Or Pictures Into Your Excel Worksheet From Other Sources. Steps:- Insert Tab > Click On The Online Pictures. (Its In The Illustrations Group.)In The Online Picture Dialog Box, Locate The Picture That You Want.Click On Insert • Bing Image Search - Bing (Default) To Use The Bing Search Engine To Locate Images On The Web Of A Particular Type That You Want To Add To Your Worksheet• One Drive Personal- One Drive To Locate Saved Images On Your Sky Drive To Add To Your Excel Worksheet Online Pictures Dialog Box Displays A Scrollable List Of Thumbnails Of The Photos Or Line Art That You Can Insert Into Your Current Worksheet.
ScreenShot In Excel

ScreenShot In Excel

Insert Menu, Menu Bar
Definition:- Using The Screenshot Option You Can Quickly And Easily Add A Screenshot To Your Worksheet To Enhance Readability Or Capture Information Without Leaving The Program That You Are Working In. This Feature Is Available In Excel Above Version Of 2007. Steps:- Insert Tab > Screenshot.Choose Window Thumbnail In Available Windows Or Use Screen Clipping.Format And Crop Your Screenshot In Excel.You Can Also Take The Quick Snap Shot Of Other Open Application And Quick Add To Your Worksheets.
SmartArt In Excel

SmartArt In Excel

Insert Menu, Menu Bar
Definition:- The Smart Art Graphics Option Is Used To Make The Information Look More Visually Good. Using These Tools From Excel, You Will Be Able To Create Great Smart Arts That Can Be Used For A Variety Of Purpose. Lets Learn How To Insert Smart Art Into A Worksheet And Customize It After Inserting It. Steps:- Insert Tab > In The Illustrations Group > Click Smart Art.In The Smart Art Graphic Dialog Box, Click The Type And Layout That You Want. 3. Enter Your Text By Doing One Of The Following: Click [Text] In The Text Pane, And Then Type Your Text.Copy Text From Another Location Or Program, Click [Text] In The Text Pane, And Then Paste Your Text. 4. Change The Colors Of An Entire Smart Art Graphic You Can Apply Color Variations That Are Derived Fr...