Tuesday, 27 March 2012

Microsoft excel shortcut key


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 time
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
Inset 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
Strike-through 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 + Pg Up &
Pg Dn
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 scientific format
Ctrl + right
Move to next section of text
Ctrl + space
Select entire column
Shift + space
Select entire row
Ctrl + W
Close document

No comments: