keyboard shortcuts for excel

document actions

• CTRL+O: Open a file
• CTRL+N: New file
• F12: Save As
• CTRL+S: Save
• CTRL+P: Print
• CTRL+F: Find
• CTRL+H: Replace
• F5: Go to

cursor movement

• up arrow: One cell up
• down arrow: One cell down
• Tab: One cell right
• SHIFT+Tab: One cell left
• CTRL+Home: Top of worksheet (cell A1)
• CTRL+End: End of worksheet (last cell with data)
• Home: End of row
• CTRL+left arrow: End of column
• CTRL+PageDown: Move to next worksheet

formulas

• ALT+=: Apply AutoSum
• CTRL+;: Current date
• CTRL+:: Current time
• F7: Spelling
• F1: Help
• ALT+F8: Macros

selecting cells

• SHIFT+left arrow: All cells left of current cell
• SHIFT+right arrow: All cells right of current cell
• CTRL+Spacebar: Entire column
• SHIFT+Spacebar: Entire row
• CTRL+A: Entire worksheet

text style

• CTRL+B: Bold
• CTRL+I: Italics
• CTRL+U: Underline
• CTRL+5: Strikethrough

formatting

• F2: Edit active cell
• SHIFT+CTRL+$: Format as currency with 2 decimal places
• SHIFT+CTRL+%: Format as percent with no decimal places
• CTRL+X: Cut
• CTRL+C: Copy
• CTRL+V: Paste
• CTRL+Z: Undo
• CTRL+Y: Redo
• CTRL+1: Format cells dialog box