Sunday, 12 August 2012

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.

No comments:

Post a Comment