Excel Keyboard Shortcut
Excel Keyboard Shortcut
Shortcut key
|
Action
|
Menu equivalent
comments |
Version
|
|
|
Ctrl+A
|
Select All
|
None
|
All
|
|
Ctrl+B
|
Bold
|
Format, Cells, Font, Font Style, Bold
|
All
|
|
Ctrl+C
|
Copy
|
Edit, Copy
|
All
|
|
Ctrl+D
|
Fill Down
|
Edit, Fill, Down
|
All
|
|
Ctrl+F
|
Find
|
Edit, Find
|
All
|
|
Ctrl+G
|
Goto
|
Edit, Goto
|
All
|
|
Ctrl+H
|
Replace
|
Edit, Replace
|
All
|
|
Ctrl+I
|
Italic
|
Format, Cells, Font, Font Style, Italic
|
All
|
|
Ctrl+K
|
Insert Hyperlink
|
Insert, Hyperlink
|
Excel 97/2000
|
|
Ctrl+N
|
New Workbook
|
File, New
|
All
|
|
Ctrl+O
|
Open
|
File, Open
|
All
|
|
Ctrl+P
|
Print
|
File, Print
|
All
|
|
Ctrl+R
|
Fill Right
|
Edit, Fill Right
|
All
|
|
Ctrl+S
|
Save
|
File, Save
|
All
|
|
Ctrl+U
|
Underline
|
Format, Cells, Font, Underline, Single
|
All
|
|
Ctrl+V
|
Paste
|
Edit, Paste
|
All
|
|
Ctrl W
|
Close
|
File, Close
|
Excel 97/2000
|
|
Ctrl+X
|
Cut
|
Edit, Cut
|
All
|
|
Ctrl+Y
|
Repeat
|
Edit, Repeat
|
All
|
|
Ctrl+Z
|
Undo
|
Edit, Undo
|
All
|
|
F1
|
Help
|
Help, Contents and Index
|
All
|
|
F2
|
Edit
|
None
|
All
|
|
F3
|
Paste Name
|
Insert, Name, Paste
|
All
|
|
F4
|
Repeat last action
|
Edit, Repeat. Works while not in Edit mode.
|
All
|
|
F4
|
While typing a formula, switch between absolute/relative refs
|
None
|
All
|
|
F5
|
Goto
|
Edit, Goto
|
All
|
|
F6
|
Next Pane
|
None
|
All
|
|
F7
|
Spell check
|
Tools, Spelling
|
All
|
|
F8
|
Extend mode
|
None
|
All
|
|
F9
|
Recalculate all workbooks
|
Tools, Options, Calculation, Calc,Now
|
All
|
|
F10
|
Activate Menubar
|
N/A
|
All
|
|
F11
|
New Chart
|
Insert, Chart
|
All
|
|
F12
|
Save As
|
File, Save As
|
All
|
|
Ctrl+:
|
Insert Current Time
|
None
|
All
|
|
Ctrl+;
|
Insert Current Date
|
None
|
All
|
|
Ctrl+"
|
Copy Value from Cell Above
|
Edit, Paste Special, Value
|
All
|
|
Ctrl+'
|
Copy Fromula from Cell Above
|
Edit, Copy
|
All
|
|
Shift
|
Hold down shift for additional functions in Excel's menu
|
none
|
Excel 97/2000
|
|
Shift+F1
|
What's This?
|
Help, What's This?
|
All
|
|
Shift+F2
|
Edit cell comment
|
Insert, Edit Comments
|
All
|
|
Shift+F3
|
Paste function into formula
|
Insert, Function
|
All
|
|
Shift+F4
|
Find Next
|
Edit, Find, Find Next
|
All
|
|
Shift+F5
|
Find
|
Edit, Find, Find Next
|
All
|
|
Shift+F6
|
Previous Pane
|
None
|
All
|
|
Shift+F8
|
Add to selection
|
None
|
All
|
|
Shift+F9
|
Calculate active worksheet
|
Calc Sheet
|
All
|
|
Shift+F10
|
Display shortcut menu
|
None
|
All
|
|
Shift+F11
|
New worksheet
|
Insert, Worksheet
|
All
|
|
Shift+F12
|
Save
|
File, Save
|
All
|
|
Ctrl+F3
|
Define name
|
Insert, Names, Define
|
All
|
|
Ctrl+F4
|
Close
|
File, Close
|
All
|
|
Ctrl+F5
|
XL, Restore window size
|
Restore
|
All
|
|
Ctrl+F6
|
Next workbook window
|
Window, ...
|
All
|
|
Shift+Ctrl+F6
|
Previous workbook window
|
Window, ...
|
All
|
|
Ctrl+F7
|
Move window
|
XL, Move
|
All
|
|
Ctrl+F8
|
Resize window
|
XL, Size
|
All
|
|
Ctrl+F9
|
Minimize workbook
|
XL, Minimize
|
All
|
|
Ctrl+F10
|
Maximize or restore window
|
XL, Maximize
|
All
|
|
Ctrl+F11
|
Inset 4.0 Macro sheet
|
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro
|
All
|
|
Ctrl+F12
|
File Open
|
File, Open
|
All
|
|
Alt+F1
|
Insert Chart
|
Insert, Chart...
|
All
|
|
Alt+F2
|
Save As
|
File, Save As
|
All
|
|
Alt+F4
|
Exit
|
File, Exit
|
All
|
|
Alt+F8
|
Macro dialog box
|
Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions
|
Excel 97/2000
|
|
Alt+F11
|
Visual Basic Editor
|
Tools, Macro, Visual Basic Editor
|
Excel 97/2000
|
|
Ctrl+Shift+F3
|
Create name by using names of row and column labels
|
Insert, Name, Create
|
All
|
|
Ctrl+Shift+F6
|
Previous Window
|
Window, ...
|
All
|
|
Ctrl+Shift+F12
|
Print
|
File, Print
|
All
|
|
Alt+Shift+F1
|
New worksheet
|
&
Visitor Rating (0.00)
 
This mail has sent to you because the sender considers you to be a friend. If you think you have received this mail in error and do not wish to receive such mails in the future, you can report it as an abuse here and we will intimate the sender. 
|
