Tuesday, November 5, 2013

EXCEL® SHORTCUT KEYS



Hey Guys today is Excel............

F2              Edit the selected cell
F5              Go to a specific cell
F7              Spell check selected text and/or document
F11           Create chart
Ctrl + Shift + ; Enter the current time
Ctrl + ;     Enter the current date
Alt + Shift + F1 Insert new worksheet
Shift + F3 Open the Excel® formula window
Shift + F5 Bring up search box
Ctrl + A    Select all contents of worksheet
Ctrl + B    Bold highlighted selection
Ctrl + I     Italicize highlighted selection
Ctrl + C   Copy selected text
Ctrl + V   Paste
Ctrl + D   Fill
Ctrl + K   Insert link
Ctrl + F   Open find and replace options
Ctrl + G  Open go-to options
Ctrl + H   Open find and replace options
Ctrl + U   Underline highlighted selection
Ctrl + Y   Underline selected text
Ctrl + 5   Strikethrough highlighted selection
Ctrl + O  Open options
Ctrl + N  Open new document
Ctrl + P  Open print dialog box
Ctrl + S  Save
Ctrl + Z  Undo last action
Ctrl + F9 Minimize current window
Ctrl + F10 Maximize currently selected window
Ctrl + F6 Switch between open workbooks/windows
Ctrl + Page up
& Page Down
Move between Excel® worksheets in the
same document
Ctrl + Tab  Move between two or more open Excel® files
Alt + =        Create formula to sum all of above cells
Ctrl + ‘       Insert value of above cell into current cell
Ctrl + Shift + !   Format number in comma format
Ctrl + Shift + $  Format number in currency format
Ctrl + Shift + #  Format number in date format
Ctrl + Shift + % Format number in percentage format
Ctrl + Shift + ^  Format number in scientific format
Ctrl + Shift + @ Format number in time format
Ctrl + g   Move to next section of text
Ctrl + Space Select entire column
Shift + Space Select entire row

Ctrl + W  Close document


Anu with PandA.
Don't miss to put a comment below.

Get Paid from here.....

Click and Earn............


iPlus Blog