MS EXCEL® SHORTCUT KEYSEXCEL® SHORTCUT KEYS

Posted by Unknown on 6:41 PM
EXCEL® SHORTCUT KEYSEXCEL® SHORTCUT KEYS
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