07/06/2026
🔹 Alt + W + F + F – Freeze or unfreeze panes ❄️
🔹 Alt + W + Q – Zoom to selection
🔹 Alt + W + V + G – Show or hide gridlines
🔹 Alt + W + V + F – Show or hide formula bar
🔹 Alt + W + V + H – Show or hide headings
🔹 Alt + W + S – Split the window
🔹 Alt + W + L – Switch between Normal, Page Layout & Page Break views
🔹 Alt + H + M + C – Merge and center
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + H + O + A – Auto-fit row height
🔹 Alt + H + B + A – Apply all borders
🔹 Alt + H + B + N – Remove all borders
🔹 Alt + H + D + C – Delete selected column
🔹 Alt + H + D + R – Delete selected row
🔹 Alt + H + O + R – Rename worksheet
🔹 Alt + A + M – Remove duplicates
🔹 Alt + A + E – Text to Columns wizard
🔹 Alt + A + T – Refresh all connections
🔹 Alt + N + V – Insert a PivotTable
🔹 Alt + N + F + S – Insert a Slicer
🔹 Alt + N + S + F – Insert a chart quickly
🔹 Ctrl + Alt + F9 – Force calculate all formulas
🔹 Ctrl + ` – Show or hide all formulas
🔹 Ctrl + Shift + L – Turn filters ON/OFF
🔹 Ctrl + Shift + & – Apply outline border
🔹 Ctrl + Shift + _ – Remove outline border
🔹 Ctrl + Shift + 7 – Add border around selection
🔹 Ctrl + Shift + U – Expand or collapse formula bar
🔹 Ctrl + Alt + T – Insert current time in Power Query
🔹 Ctrl + Shift + F3 – Create names from selection
---
✨ Quick Tip:
Use Alt + W + F + F to freeze header rows or columns, so your headings stay visible while scrolling through long data sheets 👀
---
