04/06/2025
30 useful Excel shortcuts
General Shortcuts
- Ctrl + N: Create a new workbook
- Ctrl + O: Open an existing workbook
- Ctrl + S: Save the current workbook
- Ctrl + P: Open the Print dialog
- Ctrl + Z: Undo the last action
- Ctrl + Y: Redo the last action
- Ctrl + C: Copy selected cells
- Ctrl + X: Cut selected cells
- Ctrl + V: Paste copied/cut cells
- Ctrl + F: Open the Find dialog
- Ctrl + H: Open the Find and Replace dialog
- Ctrl + A: Select all cells in the worksheet
Navigation & Selection
- Ctrl + Arrow Keys: Move to the edge of data regions
- Shift + Space: Select the entire row
- Ctrl + Space: Select the entire column
- Ctrl + Home: Go to cell A1
- Ctrl + End: Go to the last used cell
- Alt + Page Up/Down: Move one screen left/right
Formatting Shortcuts
- Ctrl + B: Apply or remove bold formatting
- Ctrl + I: Apply or remove italic formatting
- Ctrl + U: Apply or remove underline
- Ctrl + 1: Open the Format Cells dialog
- Alt + H + O + I: Auto-adjust column width
- Alt + H + O + A: Auto-adjust row height
Formula & Data Shortcuts
- F2: Edit the active cell
- Ctrl + ; : Insert current date
- Ctrl + Shift + ; : Insert current time
- Alt + = : AutoSum selected cells
- Ctrl + Shift + L: Toggle filters on/off
Dashboard & PivotTable Shortcuts
- Alt + N + V: Create a PivotTable
- Alt + F1: Create a default chart from selected data
- F11: Create a chart in a new sheet
- Ctrl + Shift + \ (or Ctrl + A in a data range): Select entire data range
- Alt + J + T + L: Refresh PivotTable data
