08/12/2025
🔹 Alt + W + Q – Zoom to selection 🔍
🔹 Alt + W + F + F – Freeze/Unfreeze panes
🔹 Alt + W + S – Split window
🔹 Alt + W + L – Switch page layout view
🔹 Alt + W + V + G – Show/Hide gridlines
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + H + O + A – Auto-fit row height
🔹 Alt + H + M + C – Merge & center
🔹 Alt + H + B + A – Apply all borders
🔹 Alt + A + E – Text to Columns
🔹 Alt + A + M – Remove duplicates
🔹 Alt + = – Auto-insert SUM
🔹 Alt + Enter – New line inside cell
🔹 Alt + N + V – Insert PivotTable
🔹 Alt + N + S + F – Insert chart
🔹 Ctrl + T – Convert range to Table
🔹 Ctrl + A – Select entire worksheet
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + F – Find
🔹 Ctrl + H – Replace
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + Shift + L – Toggle filters
🔹 Ctrl + Shift + $ – Currency format
🔹 Ctrl + Shift + % – Percentage format
🔹 Ctrl + Shift + # – Date format
🔹 Ctrl + Page Up – Previous sheet
🔹 Ctrl + Page Down – Next sheet
🔹 F2 – Edit active cell
---
✨ Quick Tip:
Use Alt + W + Q to automatically zoom into your selected data — perfect for reports, presentations, and cleaning big sheets!
---
