29/11/2025
🔹 Alt + A + E – Open Text to Columns wizard ✂️
🔹 Alt + A + M – Remove duplicates
🔹 Alt + A + T – Refresh all connections
🔹 Alt + A + G + G – Group selected rows/columns
🔹 Alt + A + G + U – Ungroup
🔹 Alt + A + S + A – Sort A → Z
🔹 Alt + A + S + D – Sort Z → A
🔹 Alt + A + Q – Data Quality options
🔹 Ctrl + T – Convert range to Table
🔹 Ctrl + Shift + L – Toggle Filters ON/OFF
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Format Cells dialog
🔹 Ctrl + Shift + $ – Apply Currency format
🔹 Ctrl + Shift + % – Apply Percentage format
🔹 Ctrl + Shift + # – Apply Date format
🔹 Ctrl + Shift + @ – Apply Time format
🔹 Ctrl + Shift + ^ – Apply Scientific format
🔹 Ctrl + Shift + Space – Select entire worksheet
🔹 Shift + Space – Select entire row
🔹 Ctrl + Space – Select entire column
🔹 Ctrl + Shift + "+" – Insert new row/column
🔹 Ctrl + "-" – Delete selected row/column
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + H + B + A – Apply all borders
🔹 Alt + W + F + F – Freeze/Unfreeze panes
🔹 Alt + = – Auto-insert SUM
🔹 F2 – Edit active cell
---
✨ Quick Tip:
Use Alt + A + E to split names, emails, codes, or addresses in seconds — one of Excel’s most powerful data-cleaning shortcuts!
---
