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