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 |