|
Excels Keyboard Shortcuts
|
|
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 |
Insert, Worksheet |
All |
|
Alt+Shift+F2 |
Save |
File, Save |
All |
|
Alt+= |
AutoSum |
No direct equivalent |
All |
|
Ctrl+` |
Toggle Value/Formula display |
Tools, Options, View, Formulas |
All |
|
Ctrl+Shift+A |
Insert argument names into formula |
No direct equivalent |
All |
|
Alt+Down arrow |
Display AutoComplete list |
None |
Excel 95 |
|
Alt+' |
Format Style dialog box |
Format, Style |
All |
|
Ctrl+Shift+~ |
General format |
Format, Cells, Number, Category, General |
All |
|
Ctrl+Shift+! |
Comma format |
Format, Cells, Number, Category, Number |
All |
|
Ctrl+Shift+@ |
Time format |
Format, Cells, Number, Category, Time |
All |
|
Ctrl+Shift+# |
Date format |
Format, Cells, Number, Category, Date |
All |
|
Ctrl+Shift+$ |
Currency format |
Format, Cells, Number, Category, Currency |
All |
|
Ctrl+Shift+% |
Percent format |
Format, Cells, Number, Category, Percentage |
All |
|
Ctrl+Shift+^ |
Exponential format |
Format, Cells, Number, Category, |
All |
|
Ctrl+Shift+& |
Place outline border around selected cells |
Format, Cells, Border |
All |
|
Ctrl+Shift+_ |
Remove outline border |
Format, Cells, Border |
All |
|
Ctrl+Shift+* |
Select current region |
Edit, Goto, Special, Current Region |
All |
|
Ctrl++ |
Insert |
Insert, (Rows, Columns, or Cells) Depends on selection |
All |
|
Ctrl+- |
Delete |
Delete, (Rows, Columns, or Cells) Depends on selection |
All |
|
Ctrl+1 |
Format cells dialog box |
Format, Cells |
All |
|
Ctrl+2 |
Bold |
Format, Cells, Font, Font Style, Bold |
All |
|
Ctrl+3 |
Italic |
Format, Cells, Font, Font Style, Italic |
All |
|
Ctrl+4 |
Underline |
Format, Cells, Font, Font Style, Underline |
All |
|
Ctrl+5 |
Strikethrough |
Format, Cells, Font, Effects, Strikethrough |
All |
|
Ctrl+6 |
Show/Hide objects |
Tools, Options, View, Objects, Show All/Hide |
All |
|
Ctrl+7 |
Show/Hide Standard toolbar |
View, Toolbars, Stardard |
All |
|
Ctrl+8 |
Toggle Outline symbols |
None |
All |
|
Ctrl+9 |
Hide rows |
Format, Row, Hide |
All |
|
Ctrl+0 |
Hide columns |
Format, Column, Hide |
All |
|
Ctrl+Shift+( |
Unhide rows |
Format, Row, Unhide |
All |
|
Ctrl+Shift+) |
Unhide columns |
Format, Column, Unhide |
All |
|
Alt or F10 |
Activate the menu |
None |
All |
|
Ctrl+Tab |
In toolbar: next toolbar |
None |
Excel 97/2000 |
|
Shift+Ctrl+Tab |
In toolbar: previous toolbar |
None |
Excel 97/2000 |
|
Ctrl+Tab |
In a workbook: activate next workbook |
None | |
 | |
|
|
| | |
