Pearson Software Consulting Services
Excel Keyboard Shortcuts
|
|
|
|
|
NOTE: These key assignments are for standard US-English keyboards. The
mappings may be slightly different on non-US-English keyboards. |
|
|
|
Key |
Alone |
Shift |
Ctrl |
Alt |
Shift Ctrl |
F1 |
Help |
What's This Help |
|
Insert Chart Sheet |
|
F2 |
Edit Mode |
Edit Comment |
|
Save As |
|
F3 |
Paste Name Formula |
Paste Function |
Define Name |
|
Names From Labels |
F4 |
Repeat Action |
Find Again |
Close Window |
Quit Excel |
Find Previous |
F5 |
Goto |
Find |
Restore Window Size |
|
|
F6 |
Next Pane |
Prev Pane |
Next Window |
Previous Window |
Prev Workbook |
F7 |
Spell Check |
|
Move Window |
|
|
F8 |
Extend Selection |
Add To Selection |
Resize Window |
Macro List |
|
F9 |
Calculate All |
Calculate Worksheet |
Minimize Workbook |
|
|
F10 |
Activate Menu |
Context Menu |
Maximize Window |
|
|
F11 |
New Chart |
New Worksheet |
New Macro Sheet |
VB Editor |
|
F12 |
Save As |
Save |
Open |
|
Print |
A |
|
|
Select All |
|
Formula Arguments |
B |
|
|
Bold |
|
|
C |
|
|
Copy |
|
|
D |
|
|
Fill Down |
Data Menu |
|
E |
|
|
|
Edit Menu |
|
F |
|
|
Find |
File Menu |
Font Name |
G |
|
|
Goto |
|
|
H |
|
|
Replace |
Help Menu |
|
I |
|
|
Italics |
Insert Menu |
|
J |
|
|
|
|
|
K |
|
|
Insert Hyperlink |
|
|
L |
|
|
|
|
|
M |
|
|
|
|
|
N |
|
|
New Workbook |
|
|
O |
|
|
Open Workbook |
Format Menu |
Select Comments |
P |
|
|
Print |
|
Font Size |
Q |
|
|
|
|
|
R |
|
|
Fill Right |
|
|
S |
|
|
Save |
|
|
T |
|
|
|
Tools Menu |
|
U |
|
|
Underline |
|
|
V |
|
|
Paste |
|
|
W |
|
|
Close Workbook |
Window Menu |
|
X |
|
|
Cut |
|
|
Y |
|
|
Repeat Active |
|
|
Z |
|
|
Undo |
|
|
` (~) |
|
|
Toggle Formula View |
|
General Format |
1 (!) |
|
|
Cell Format |
|
Number Format |
2 (@) |
|
|
Toggle Bold |
|
Time Format |
3 (#) |
|
|
Toggle Italics |
|
Date Format |
4 ($) |
|
|
Toggle Underline |
|
Currency Format |
5 (%) |
|
|
Toggle Strikethru |
|
Percent Format |
6 (^) |
|
|
Toggle Object Display |
|
Exponent Format |
7 (&) |
|
|
Show/Hide Standard Toolbar |
|
Apply Border |
8 (*) |
|
|
Outline |
|
Select Region |
9 (() |
|
|
Hide Rows |
|
Unhide Rows |
0 ()) |
|
|
Hide Columns |
|
Unhide Columns |
- |
|
|
Delete Selection |
Control Menu |
No Border |
= (+) |
Formula |
|
Calculate All |
Auto Sum |
Insert Cells |
[ |
|
|
Direct Precendents |
|
All Precendents |
] |
|
|
Direct Dependents |
|
All Dependents |
; (semicolon) |
|
|
Insert Date |
Select Visible Cells |
Insert Time |
' (apostrophe) |
|
|
Copy Formula From Above |
Style |
Copy Value Above |
: (colon) |
|
|
Insert Time |
|
|
/ |
|
|
Select Array |
|
Select Array |
\ |
|
|
Select Differences |
|
Select Unequal Cells |
Insert |
Insert Mode |
|
Copy |
|
|
Delete |
Clear |
|
Delete To End Of Line |
|
|
Home |
Begin Row |
|
Start Of Worksheet |
|
|
End |
End Row |
|
End Of Worksheet |
|
|
Page Up |
Page Up |
|
Previous Worksheet |
Left 1 screen |
|
Page Down |
Page Down |
|
Next Worksheet |
Right 1 screen |
|
Left Arrow |
Move Left |
Select Left |
Move Left Area |
|
|
Right Arrow |
Move Right |
Select Right |
Move Right Area |
|
|
Up Arrow |
Move Up |
Select Up |
Move Up Area |
|
|
Down Arrow |
Move Down |
Select Down |
Move Down Area |
Drop down list |
|
Space Bar |
Space |
Select Row |
Select Column |
Control Box |
Select All |
Tab |
Move Right |
Move Left |
Next Window |
Next Application |
Previous Window |
Enter |
|
Move Up |
Fill Selection With Active Cell |
Insert Row |
|
BackSpace |
|
Collapse Selection To
Active Cell |
Goto Active Cell |
|
|
|
|
|
You can download this as an Excel workbook
here. |
|
|
|
|
|
|
Created By Chip Pearson and
Pearson Software Consulting, LLC
This Page:
Updated: November 06, 2013
MAIN PAGE
About This Site
Consulting
Downloads
Page Index
Search
Topic Index
What's New
Links
Legalese And Disclaimers
chip@cpearson.com
© Copyright 1997-2007 Charles H. Pearson