Greenfield Institute

31/10/2025

28/10/2025

🔹 Ctrl + T – Convert selected range into a table 📊
🔹 Ctrl + Shift + L – Add or remove filters
🔹 Ctrl + Shift + $ – Apply currency format
🔹 Ctrl + Shift + % – Apply percentage format
🔹 Ctrl + Shift + # – Apply date format
🔹 Ctrl + Shift + @ – Apply time format
🔹 Ctrl + Shift + ^ – Apply exponential format
🔹 Alt + N + S + F – Insert chart instantly
🔹 Alt + N + F + S – Insert a slicer for PivotTables
🔹 Alt + A + M – Remove duplicates
🔹 Alt + A + E – Text to Columns wizard
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + H + O + A – Auto-fit row height
🔹 Alt + W + F + F – Freeze or unfreeze panes
🔹 Alt + H + D + C – Delete entire column
🔹 Alt + H + D + R – Delete entire row
🔹 Alt + H + B + A – Apply all borders
🔹 Alt + H + B + N – Remove all borders
🔹 Alt + H + B + T – Add top border
🔹 Alt + H + B + L – Add left border
🔹 Ctrl + Shift + "+" – Insert new row or column
🔹 Ctrl + “–” – Delete selected row or column
🔹 Ctrl + 0 – Hide selected column
🔹 Ctrl + 9 – Hide selected row
🔹 Ctrl + Shift + 0 – Unhide columns
🔹 Ctrl + Shift + 9 – Unhide rows
🔹 Alt + W + V + G – Show or hide gridlines
🔹 Alt + W + Q – Zoom to selection
🔹 Alt + W + V + F – Show or hide formula bar
🔹 Alt + M + U – Show all formulas

Quick Tip:
Use Ctrl + T to instantly transform plain data into a smart Excel Table — with filters, sorting, and automatic formula expansion. It’s a must-use for every pro!

08/10/2025