Shortcut tips

  ✴️ Shortcut tips ✴️

🔹 Ctrl + Shift + $ – Currency format

🔹 Ctrl + Shift + @ – Time format

🔹 Ctrl + Page Down – Next sheet

🔹 Ctrl + Space – Select entire column

🔹 Ctrl + Shift + + (Plus) – Insert row/column

🔹 Alt + F8 – Open macro dialog

🔹 Ctrl + Shift + L – Toggle filters on/off

🔹 Ctrl + T – Create table

🔹 Alt + H + O + A – Auto-fit row height

🔹 Ctrl + Shift + ! – Number format

🔹 Ctrl + + (Plus) – Insert cells

🔹 Alt + H + O + I – Auto-fit column width

🔹 Alt + A + M – Remove duplicates

🔹 Alt + W + F – Freeze panes

🔹 Shift + Space – Select entire row

🔹 Ctrl + Shift + ~ – General number format

🔹 F9 – Calculate all worksheets

🔹 Ctrl + Page Up – Previous sheet

🔹 F2 – Edit active cell

🔹 Alt + W + S – Split window

🔹 Alt + N + V – Create PivotTable

🔹 Alt + Tab – Switch between applications

🔹 Ctrl + Shift + # – Date format

🔹 Ctrl + - (Minus) – Delete selection

🔹 Ctrl + F6 – Switch between workbooks

🔹 Alt + E + S + V – Paste special values

🔹 Shift + F3 – Insert function

🔹 Ctrl + F3 – Define name

🔹 Ctrl + Shift + % – Percentage format

🔹 F4 – Repeat last action

💡 Tip: Use Ctrl + Shift + L to quickly add/remove filters from your data headers!