🔹 Alt + H + O + I - AutoFit column width
🔹 Ctrl + 1 - Format Cells dialog
🔹 Ctrl + T - Create table
🔹 Ctrl + Space - Select entire column
🔹 Shift + Space - Select entire row
🔹 Ctrl + Arrow Keys - Navigate data edges
🔹 Ctrl + Shift + L - Toggle filters
🔹 Alt + N + V - Insert PivotTable
🔹 Alt + A + M - Remove duplicates
🔹 Ctrl + D - Fill down
🔹 Ctrl + R - Fill right
🔹 Ctrl + - (Minus) - Delete selection
🔹 Ctrl + E - Flash Fill
🔹 Alt + = - AutoSum
🔹 Ctrl + ; - Insert current date
🔹 Ctrl + Shift + ; - Insert current time
🔹 Ctrl + Shift + + (Plus) - Insert cells
🔹 Alt + E + S + V - Paste values
🔹 Alt + H + O + A - AutoFit row height
🔹 F2 - Edit active cell
🔹 F4 - Repeat last action/Toggle references
🔹 F9 - Calculate worksheets
🔹 Shift + F3 - Insert function
🔹 Ctrl + F3 - Name Manager
🔹 Alt + F1 - Create embedded chart
🔹 F11 - Create chart in new sheet
🔹 Ctrl + Shift + $ - Currency format
🔹 Ctrl + Shift + % - Percentage format
🔹 Alt + W + F - Freeze panes
🔹 Ctrl + Page Up/Down - Switch worksheets
Pro Tip:Use Alt + H + O + I to instantly resize columns to fit your data!
Comments
Post a Comment