🔹 Alt + D + S - Open Sort dialog
🔹 Ctrl + E - Flash Fill
🔹 Alt + A + E - Text to Columns
🔹 Alt + N + V - Create PivotTable
🔹 Alt + A + M - Remove duplicates
🔹 Ctrl + T - Create table
🔹 Ctrl + Space - Select entire column
🔹 Shift + Space - Select entire row
🔹 Ctrl + - (Minus) - Delete selection
🔹 Ctrl + + (Plus) - Insert cells
🔹 Ctrl + Shift + L - Toggle filters
🔹 Alt + W + F - Freeze panes
🔹 Alt + W + S - Split window
🔹 Ctrl + Page Up - Previous sheet
🔹 Ctrl + Page Down - Next sheet
🔹 Alt + E + S + V - Paste values
🔹 Alt + H + O + I - Auto-fit column width
🔹 Alt + H + O + A - Auto-fit row height
🔹 Ctrl + 1 - Format Cells dialog
🔹 F2 - Edit cell
🔹 F4 - Repeat last action/Toggle references
🔹 F9 - Calculate worksheets
🔹 Shift + F3 - Insert function
🔹 Ctrl + F3 - Define name
🔹 Alt + F8 - Macro dialog
🔹 Ctrl + Shift + : - Insert time
🔹 Ctrl + ; - Insert date
🔹 Alt + = - AutoSum
🔹 Ctrl + Shift + $ - Currency format
🔹 Ctrl + Shift + % - Percentage format
Bonus: Use Alt + D + S for multi-column sorting (Data > Sort in newer versions).
Comments
Post a Comment