🔥 Navigation & Selection
- Ctrl + Arrow Key – Jump to the edge of a data region
- Ctrl + Shift + Arrow Key – Select data to the edge
- Ctrl + Home – Go to cell A1
- Ctrl + End – Go to last used cell
- F5 → Special – Select blanks, formulas, constants, etc.
🧠 Editing & Data Entry
- Alt + Enter – New line inside a cell
- Ctrl + D – Fill down
- Ctrl + R – Fill right
- Ctrl + ; – Insert current date
- Ctrl + Shift + : – Insert current time
📊 Formatting Like a Pro
- Ctrl + 1 – Open Format Cells dialog
- Ctrl + Shift + $ – Currency format
- Ctrl + Shift + % – Percentage format
- Ctrl + Shift + # – Date format
- Ctrl + Shift + ! – Number format (commas + 2 decimals)
⚡ Rows, Columns & Sheets
- Ctrl + Space – Select entire column
- Shift + Space – Select entire row
- Ctrl + + – Insert row/column
- Ctrl + - – Delete row/column
- Shift + F11 – Create new worksheet instantly
🔍 Power User Tricks
- Ctrl + ` – Show / hide formulas
- Alt + = – AutoSum
- Ctrl + Shift + L – Toggle filters
- Ctrl + K – Insert hyperlink
- F4 – Repeat last action (or toggle
$in formulas)
