| Shortcut
key |
Action |
Menu equivalent
comments
|
| Ctrl+A |
Select
All |
None |
| Ctrl+B |
Bold |
Format,
Cells, Font, Font Style, Bold |
| Ctrl+C |
Copy |
Edit,
Copy |
| Ctrl+D |
Fill
Down |
Edit,
Fill, Down |
| Ctrl+F |
Find |
Edit,
Find |
| Ctrl+G |
Goto |
Edit,
Goto |
| Ctrl+H |
Replace |
Edit,
Replace |
| Ctrl+I |
Italic |
Format,
Cells, Font, Font Style, Italic |
| Ctrl+K |
Insert
Hyperlink |
Insert,
Hyperlink |
| Ctrl+N |
New
Workbook |
File,
New |
| Ctrl+O |
Open |
File,
Open |
| Ctrl+P |
Print |
File,
Print |
| Ctrl+R |
Fill
Right |
Edit,
Fill Right |
| Ctrl+S |
Save |
File,
Save |
| Ctrl+U |
Underline |
Format,
Cells, Font, Underline, Single |
| Ctrl+V |
Paste |
Edit,
Paste |
| Ctrl W |
Close |
File,
Close |
| Ctrl+X |
Cut |
Edit,
Cut |
| Ctrl+Y |
Repeat |
Edit,
Repeat |
| Ctrl+Z |
Undo |
Edit,
Undo |
| F1 |
Help |
Help,
Contents and Index |
| F2 |
Edit |
None |
| F3 |
Paste
Name |
Insert,
Name, Paste |
| F4 |
Repeat
last action |
Edit,
Repeat. Works while not in Edit mode. |
| F4 |
While
typing a formula, switch between absolute/relative refs |
None |
| F5 |
Goto |
Edit,
Goto |
| F6 |
Next
Pane |
None |
| F7 |
Spell
check |
Tools,
Spelling |
| F8 |
Extend
mode |
None |
| F9 |
Recalculate
all workbooks |
Tools,
Options, Calculation, Calc Now |
| F10 |
Activate
Menubar |
N/A |
| F11 |
New
Chart |
Insert,
Chart |
| F12 |
Save
As |
File,
Save As |
| Shift + Ctrl+: |
Insert
Current Time |
None |
| Ctrl+; |
Insert
Current Date |
None |
| Ctrl+" |
Copy
Value from Cell Above |
Edit,
Paste Special, Value |
| Ctrl+’ |
Copy
Formula from Cell Above |
Edit,
Copy |
| Shift |
Hold
down shift for additional functions in Excel’s menu |
none |
| Shift+F1 |
What’s
This? |
Help,
What’s This? |
| Shift+F2 |
Edit
cell comment |
Insert,
Edit Comments |
| Shift+F3 |
Paste
function into formula |
Insert,
Function |
| Shift+F4 |
Find
Next |
Edit,
Find, Find Next |
| Shift+F5 |
Find |
Edit,
Find, Find Next |
| Shift+F6 |
Previous
Pane |
None |
| Shift+F8 |
Add
to selection |
None |
| Shift+F9 |
Calculate
active worksheet |
Tools,
Options, Calculation, Calc Sheet |
| Ctrl+Alt+F9 |
Calculate
all worksheets in all open workbooks, regardless of whether they have changed
since the last calculation. |
None |
| Ctrl+Alt+Shift+F9 |
Rechecks
dependent formulas and then calculates all cells in all open workbooks,
including cells not marked as needing to be calculated. |
None |
| Shift+F10 |
Display
shortcut menu |
None |
| Shift+F11 |
New
worksheet |
Insert,
Worksheet |
| Shift+F12 |
Save |
File,
Save |
| Ctrl+F3 |
Define
name |
Insert,
Names, Define |
| Ctrl+F4 |
Close |
File,
Close |
| Ctrl+F5 |
XL,
Restore window size |
Restore |
| Ctrl+F6 |
Next
workbook window |
Window,
... |
| Shift+Ctrl+F6 |
Previous
workbook window |
Window,
... |
| Ctrl+F7 |
Move
window |
XL,
Move |
| Ctrl+F8 |
Resize
window |
XL,
Size |
| Ctrl+F9 |
Minimize
workbook |
XL,
Minimize |
| Ctrl+F10 |
Maximize
or restore window |
XL,
Maximize |
| Ctrl+F11 |
Inset
4.0 Macro sheet |
None
in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro |
| Ctrl+F12 |
File
Open |
File,
Open |
| Alt+F1 |
Insert
Chart |
Insert,
Chart... |
| Alt+F2 |
Save
As |
File,
Save As |
| Alt+F4 |
Exit |
File,
Exit |
| Alt+F8 |
Macro
dialog box |
Tools,
Macro, Macros in Excel 97 Tools,Macros - in earlier versions |
| Alt+F11 |
Visual
Basic Editor |
Tools,
Macro, Visual Basic Editor |
| Ctrl+Shift+F3 |
Create
name by using names of row and column labels |
Insert,
Name, Create |
| Ctrl+Shift+F6 |
Previous
Window |
Window,
... |
| Ctrl+Shift+F12 |
Print |
File,
Print |
| Alt+Shift+F1 |
New
worksheet |
Insert,
Worksheet |
| Alt+Shift+F2 |
Save |
File,
Save |
| Alt+= |
AutoSum |
No
direct equivalent |
| Ctrl+` |
Toggle
Value/Formula display |
Tools,
Options, View, Formulas |
| Ctrl+Shift+A |
Insert
argument names into formula |
No
direct equivalent |
| Alt+Down arrow |
Display
AutoComplete list |
None |
| Alt+’ |
Format
Style dialog box |
Format,
Style |
| Ctrl+Shift+~ |
General
format |
Format,
Cells, Number, Category, General |
| Ctrl+Shift+! |
Comma
format |
Format,
Cells, Number, Category, Number |
| Ctrl+Shift+@ |
Time
format |
Format,
Cells, Number, Category, Time |
| Ctrl+Shift+# |
Date
format |
Format,
Cells, Number, Category, Date |
| Ctrl+Shift+$ |
Currency
format |
Format,
Cells, Number, Category, Currency |
| Ctrl+Shift+% |
Percent
format |
Format,
Cells, Number, Category, Percentage |
| Ctrl+Shift+^ |
Exponential
format |
Format,
Cells, Number, Category, |
| Ctrl+Shift+& |
Place
outline border around selected cells |
Format,
Cells, Border |
| Ctrl+Shift+_ |
Remove
outline border |
Format,
Cells, Border |
| Ctrl+Shift+* |
Select
current region |
Edit,
Goto, Special, Current Region |
| Ctrl++ |
Insert |
Insert,
(Rows, Columns, or Cells) Depends on selection |
| Ctrl+- |
Delete |
Delete,
(Rows, Columns, or Cells) Depends on selection |
| Ctrl+1 |
Format
cells dialog box |
Format,
Cells |
| Ctrl+2 |
Bold |
Format,
Cells, Font, Font Style, Bold |
| Ctrl+3 |
Italic |
Format,
Cells, Font, Font Style, Italic |
| Ctrl+4 |
Underline |
Format,
Cells, Font, Font Style, Underline |
| Ctrl+5 |
Strikethrough |
Format,
Cells, Font, Effects, Strikethrough |
| Ctrl+6 |
Show/Hide
objects |
Tools,
Options, View, Objects, Show All/Hide |
| Ctrl+7 |
Show/Hide
Standard toolbar |
View,
Toolbars, Stardard |
| Ctrl+8 |
Toggle
Outline symbols |
None |
| Ctrl+9 |
Hide
rows |
Format,
Row, Hide |
| Ctrl+0 |
Hide
columns |
Format,
Column, Hide |
| Ctrl+Shift+( |
Unhide
rows |
Format,
Row, Unhide |
| Ctrl+Shift+) |
Unhide
columns |
Format,
Column, Unhide |
| Alt or F10 |
Activate
the menu |
None |
| Ctrl+Tab |
In
toolbar: next toolbar |
None |
| Shift+Ctrl+Tab |
In
toolbar: previous toolbar |
None |
| Ctrl+Tab |
In
a workbook: activate next workbook |
None |
| Shift+Ctrl+Tab |
In
a workbook: activate previous workbook |
None |
| Tab |
Next
tool |
None |
| Shift+Tab |
Previous
tool |
None |
| Enter |
Do
the command |
None |
| Alt+Enter |
Start
a new line in the same cell. |
None |
| Ctrl+Enter |
Fill
the selected cell range with the current entry. |
None |
| Shift+Ctrl+F |
Font
Drop Down List |
Format,
Cells, Font |
| Shift+Ctrl+F+F |
Font
tab of Format Cell Dialog box |
Format,
Cells, Font |
| Shift+Ctrl+P |
Point
size Drop Down List |
Format,
Cells, Font |
|
|
|
|
|
|
| Shorcuts
for the Visual Basic Editor |
|
|
|
|
|
| Shortcut
key |
Action |
Menu equivalent
comments |
| F1 |
Help |
Help |
| F2 |
View
Object Browser |
View,
Object Browser |
| F3 |
Find
Next |
|
| F4 |
Properies
Window |
View,
Properties Window |
| F5 |
Run
Sub/Form or Run Macro |
Run,
Run Macro |
| F6 |
Switch
Split Windows |
|
| F7 |
View
Code Window |
View,
Code |
| F8 |
Step
Into |
Debug,
Step Into |
| F9 |
Toggle
Breakpoint |
Debug,
Toggle Breakpoint |
| F10 |
Activate
Menu Bar |
|
| Shift+F2 |
View
definition |
View,
Definition |
| Shift+F3 |
Find
Previous |
|
| Shift+F7 |
View
Object |
View,
Object |
| Shift+F8 |
Step
Over |
Debug,
Step Over |
| Shift+F9 |
Quick
Watch |
Debug,
Quick Watch |
| Shift+F10 |
Show
Right Click Menu |
|
| Ctrl+F2 |
Focus
To Object Box |
|
| Ctrl+F4 |
Close
Window |
|
| Ctrl+F8 |
Run
To Cursor |
Debug,
Run To Cursor |
| Ctrl+F10 |
Activate
Menu Bar |
|
| Alt+F4 |
Close
VBE |
File,
Close and Return to Microsoft Excel |
| Alt+F6 |
Switch
Between Last 2 Windows |
|
| Alt+F11 |
Return
To Application |
|
| Ctrl+Shift+F2 |
Go
to last position |
View,
Last Position |
| Ctrl+Shift+F8 |
Step
Out |
Debug,
Step Out |
| Ctrl+Shift+F9 |
Clear
All Breakpoints |
Debug,
Clear All Breakpoints |
| Insert |
Toggle
Insert Mode |
|
| Delete |
Delete |
Edit,
Clear |
| Home |
Move
to beginning of line |
|
| End |
Move
to end of line |
|
| Page Up |
Page
Up |
|
| Page Down |
Page
Down |
|
| Left Arrow |
Left |
|
| Right Arrow |
Right |
|
| Up Arrow |
Up |
|
| Down Arrow |
Down |
|
| Tab |
Indent |
Edit,
Indent |
| Enter |
New
Line |
|
| BackSpace |
Delete
Prev Char |
|
| Shift+Insert |
Paste |
Edit,
Paste |
| Shift+Home |
Select
To Start Of Line |
|
| Shift+End |
Select
To End Of Line |
|
| Shift+Page Up |
Select
To Top Of Module |
|
| Shift+Page Down |
Select
To End Of Module |
|
| Shift+Left Arrow |
Extend
Selection Left 1 Char |
|
| Shift+Right Arrow |
Extend
Selection Right 1 Char |
|
| Shift+Up Arrow |
Extend
Selection Up |
|
| Shift+Down Arrow |
Extend
Selection Down |
|
| Shift+Tab |
Outdent |
Edit,
Outdent |
| Alt+Spacebar |
System
Menu |
|
| Alt+Tab |
Cycle
Applications |
|
| Alt+BackSpace |
Undo |
|
| Ctrl+A |
Select
All |
Edit,
Select All |
| Ctrl+C |
Copy |
Edit,
Copy |
| Ctrl+E |
Export
Module |
File,
Export File |
| Ctrl+F |
Find |
Edit,
Find… |
| Ctrl+G |
Immediate
Window |
View,
Immediate Window |
| Ctrl+H |
Replace |
Edit,
Replace… |
| Ctrl+I |
Turn
On Quick Info |
Edit,
Quikc Info |
| Ctrl+J |
List
Properties/Methods |
Edit,
List Properties/Methods |
| Ctrl+L |
Show
Call Stack |
|
| Ctrl+M |
Import
File |
File,
Import File |
| Ctrl+N |
New
Line |
|
| Ctrl+P |
Print |
File,
Print |
| Ctrl+R |
Project
Explorer |
View,
Project Explorer |
| Ctrl+S |
Save |
File,
Save |
| Ctrl+T |
Show
Available Components |
Insert,
Components…
|
| Ctrl+V |
Paste |
Edit,
Paste |
| Ctrl+X |
Cut |
Edit,
Cut |
| Ctrl+Y |
Cut
Entire Line |
|
| Ctrl+Z |
Undo |
Edit,
Undo |
| Ctrl+Insert |
Copy |
Edit,
Copy |
| Ctrl+Delete |
Delete
To End Of Word |
|
| Ctrl+Home |
Top
Of Module |
|
| Ctrl+End |
End
Of Module |
|
| Ctrl+Page Up |
Top
Of Current Procedure |
|
| Ctrl+Page Down |
End
Of Current Procedure |
|
| Ctrl+Left Arrow |
Move
one word to left |
|
| Ctrl+Right Arrow |
Move
one word to right |
|
| Ctrl+Up Arrow |
Previous
Procedure |
|
| Ctrl+Down Arrow |
Next
Procedure |
|
| Ctrl+Spacebar |
Complete
Word |
Edit,
Complete Word |
| Ctrl+Tab |
Cycle
Windows |
|
| Ctrl+BackSpace |
Delete
To Start Of Word |
|
| Ctrl+Shift+I |
Parameter
Info |
Edit,
Parameter Info |
| Ctrl+Shift+J |
List
Constants |
Edit,
List Constants |