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
|
Tuesday, 27 March 2012
Microsoft excel shortcut key
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment