Keyboard Shortcuts

While there are many keyboard shortcuts in Excel, the following are particularly helpful:

KEYSTROKE DESCRIPTION
Navigating Shortcuts  
Alt + Tab    Toggle between programs
Ctrl + Esc Show the Windows Start menu
Ctrl + Tab   Toggle between open Excel files
Ctrl + PageUp (PageDown) Move between worksheets within the active file
Shift + Ctrl + PageUp (PageDown) Select multiple worksheets within the active file
Home Move to the beginning of the line
Ctrl + Home Move to the beginning of the worksheet
Ctrl + End Move to the last cell on the worksheet
End (press and release) + Arrow Keys Move by one block of data within a row or column
Ctrl + [  / Ctrl + ] Jump to precedent cells / Jump to dependent cells
F5 (Go To) and then Enter Return to the last cell visited
   
Function Shortcuts  
Ctrl + N Create a new file
Ctrl + O Open an existing file
Ctrl + P Print
Ctrl + S Save
Ctrl + W Close the existing file
Alt + = Sum a column
Ctrl + Shift + A Prompts to edit a formula
   
Function Keys  
F1 Display Help
F2 Edit the active cell
F4 (Ctrl+Y) Repeat the last action
F4 Absolute referencing
F5 (Ctrl+G) Go To
F7 Spell check
F9 Calculate (manual)
   
Editing Shortcuts  
F2 Edit the active cell
Ctrl + C Copy
Ctrl + D Copy down
Ctrl + F Find
Ctrl + G Go To
Ctrl + H Replace
Ctrl + R Copy right
Ctrl + V Paste
Ctrl + X Cut
Ctrl + Y Repeat last action
Ctrl + Z Undo last action
Alt + Enter Start new line in same cell
Ctrl + Delete Delete text to end of line
   
Formatting Shortcuts  
Ctrl + 1 Display the Format Cells command
Ctrl + B Apply Bold formatting
Ctrl + I Apply Italic formatting
Ctrl + U Underline cells
Ctrl + ; Enter the date
Ctrl + Shift + ; Enter the time
Ctrl + Shift + $ Apply currency format
Ctrl + Shift + % Apply percent format
Ctrl + Shift + & Apply an outline border
Ctrl + Shift + _ Remove an outline border
   
Selecting Cells  
Ctrl + A Select entire sheet
Ctrl + Spacebar Select the column
Shift + Spacebar Select the row
Alt + Shift + Right (Left) Arrow  Group (ungroup) selected rows or columns
Shift + End + Arrow Keys Extend the selection to the last non-blank cell in the same row or column