Fill down | Ctrl + D |
Insert cells | Ctrl + Shift + + (plus) |
Insert cut cells | Ctrl + Shift + + (plus) |
Cut value | Ctrl + X |
Delete the characters of the active cell | Backspace |
Delete character to the left | Backspace |
Delete character to the right | Delete |
Delete characters to the end of the line | Ctrl + Delete |
Shift cells up | Ctrl + – (minus) |
Open file | Ctrl + O |
Open dialog box | Ctrl + F12 |
Hide window | Alt + W + H |
Unhide window | Alt + W + U |
Close Excel | Alt + F4 |
Close active book | Ctrl + W |
Row | |
Insert row | Ctrl + Shift + + (plus) |
Insert multiple rows | Ctrl + Shift + + (plus) |
Insert row above | Ctrl + Shift + + (plus) |
Insert row below | Assigning shortcut keys to VBA |
Delete row | Ctrl + – (minus) |
Delete blank row | Ctrl + – (minus) |
Get the bottom of current row | Ctrl + ↓ (down arrow key) |
Select by one cell to the left or right | Shift + ← (left arrow) Shift + → (right arrow) |
Select entire row | Shift + Space |
Extend select to start of row | Shift + Home |
Extend select to end of row | Ctrl + Shift + → (right arrow) |
Row height | Alt + H + O + H |
AutoFit row | Alt + H + O + A |
Hide row | Ctrl + 9 |
Unhide row | Ctrl + Shift + 9 |
Freeze top row | Alt + W + F + R |
Freeze multiple rows | Alt + W + F + F |
Highlight row | Shift + Space Alt + H + H |
Column | |
Insert column | Ctrl + Shift + + (plus) |
Delete column | Ctrl + – (minus) |
Select by one cell to the above or below | Shift + ↑ (up arrow key) Shift + ↓ (down arrow key) |
Select entire column | Ctrl + Space |
Select to end of column | Ctrl + Shift + ↓ (down arrow) |
Select entire column with data | Ctrl + Shift + ↑ (up arrow) Ctrl + Shift + ↓ (down arrow) |
Column selection by one screen | Shift + PgUp Shift + PgDn |
Select cells that do not match the active cell | Ctrl + Shift + | (vertical bar) |
AutoFit column | Alt + H + O + I (ai) |
Set the value for column width | Alt + H + O + W |
Copy only column width to another column | Ctrl + Alt + V, W |
Hide column | Ctrl + 0 (zero) |
Unhide column | Alt + H + O + U + L |
Unhide data in the same column | Alt + ↓ (down arrow key) |
Freeze the first column | Alt + W + F + C |
Freeze columns and rows in any cell | Alt + W + F + F |
Highlight entire column | Ctrl + Space Alt + H + H |
Text to column | Alt + A + E |
Sheet | |
New sheet | Shift + F11 |
Select entire sheet | Ctrl + A |
Select the current and previous sheet | Ctrl + Shift + PgUp
|
Select the current and next sheet | Ctrl + Shift + PgDn |
Switch sheet | Ctrl + PgUp Ctrl + PgDn |
Next sheet | Ctrl + PgDn |
Move sheet | Alt + E + M |
Copy sheet | Alt + E + M |
Rename sheet | Alt + H + O + R |
Sheet tab color change | Alt + H + O + T |
Protect Sheet | Alt + R + P + S |
Delete sheet | Alt + E + L |
Close only one sheet | Alt + E + L |
Close all sheets | Ctrl + W |
Move | |
Move to other cells | ↑ or ↓ or → or ← (Arrow key) |
Move to the cell on the edge of the data | Ctrl + ↑ or ↓ or → or ← (Arrow key) |
Format | |
bold | Ctrl + B |
Strikethrough | Ctrl + 5 |
Left alignment | Alt + H + A + L |
Center alignment | Alt + H + A + C |
Right alignment | Alt + H + A + R |
Top alignment | Alt + H + A + T |
Middle alignment | Alt + H + A + M |
Bottom alignment | Alt + H + A + B |
Copy format | Alt + H + F + P |
Format painter | Alt + H + F + P |
Format cell | Ctrl + 1 |
Font tab | Ctrl + Shift + P |
Increase font size | Alt + H + F + G |
Set any font size | Ctrl + Shift + F |
All border | Alt + H + B + A |
Bottom border | Alt + H + B + O |
Top border | Alt + H + B + P |
Left border | Alt + H + B + L |
Right border | Alt + H + B + R |
No border | Alt + H + B + N |
Outside border | Alt + H + B + S |
Thick outside border | Alt + H + B + T |
Bottom double border | Alt + H + B + B |
Thick bottom border | Alt + H + B + H |
Top and bottom border | Alt + H + B + D |
Wrap text | Alt + H + W |
Number format | Ctrl + Shift + 1 |
Time format | Ctrl + Shift + @ |
Current time | Ctrl + Shift + : (colon) |
Date Format | Ctrl + Shift + # |
Today’s date | Ctrl + ; (semicolon) |
Apply currency format | Ctrl + Shift + $ |
Apply percentage format | Ctrl + Shift + % |
Apply scientific format | Ctrl + Shift + ^ (caret) |
Apply general format | Ctrl + Shift + ~ (tilde) |
Up and Down Arrows | Alt + H + L + I (ai), Enter |
New Formatting Rule | Alt + H + L + N |
Top/Bottom rules | Alt + H + L + T |
Merge cell | Alt+ H + M + M |
Merge and center | Alt + H + M + C |
Merge cells horizontally only | Alt + H + M + A |
Unmerge cell | Alt + H + M + U |
Highlight cells rules | Alt + H + L + H |
Highlight cells yellow | Alt + H + H |
Data bars | Alt + H + L + D |
Color palette | Alt + H + H |
Colors dialog box | Alt + H + H + M |
Color scales | Alt + H + L + S |
Conditional Formatting Rules Manager | Alt + O + D |
Superscript | Ctrl + Shift + P |
Subscript | Ctrl + Shift + P |
Format Cells dialog box | Ctrl + 1 |
Symbol dialog box | Alt + N + Z + S + U |
Formula/Function | |
Cursor to formula bar | F2 Setup required |
Edit formula | F2 |
Drag formula | Ctrl + Enter |
Formula bar wider | Ctrl + Shift + U |
Show formula | Ctrl+ Shift + ` (grave accent) |
Show all formula | Alt + M + H |
Copy formula down | Ctrl + D |
Multiply formula | Ctrl + Alt + V, M |
Remove formula | Ctrl + Alt + V, V |
Absolute reference | F4 |
Insert argument names into formula | Ctrl + Shift + A |
| |
Select cells that are directly referenced in a formula | Ctrl + [ |
Select cells with formulas that directly reference the cell | Ctrl + ] |
Insert function | Shift + F3 |
Calculate sum | Alt + H + U + S |
AutoSum | Alt + = |
Subtotal | Alt + A + B |
Calculate average | Alt + M + U + A |
Absolute value | Alt + M + G |
Pivot table | |
PivotTable | Alt + N + V + T |
PivotTable & PivotChart Wizard | Alt + D + P |
Update a specific pivot table | Alt + F5 |
Update all pivot tables | Ctrl + Alt + F5 |
Macro/VBA | |
Open the Macro | Alt + F8 |
Open VBA | Alt + F11 |
Others | |
Select all cells from the current cell to A1 | Ctrl + Shift + Home |
Select only the active cell when multiple cells are selected | Shift + Backspace |
First letter capital | Alt + M + T |
Small letter | Alt + M + T |
capital letters | Alt + M + T |
Hide ribbon | Ctrl + F1 |
Unhide ribbon | Ctrl + F1 |
Get the bottom cell | Ctrl + End |
Search | Ctrl + F |
Find next | Shift + F4 |
Find previous | Ctrl + Shift + F4 |
Go to a specific cell | F5 |
Remove newline | Ctrl + H Operation required |
Select all cells with Notes | Ctrl + Shift + O |
Insert notes | Shift + F2 |
Insert comment | Ctrl +Shift + F2 |
Delete comment | Alt + R + D |
Data validation | Alt + D + L |
Hide object | Ctrl + 6 |
Flash fill | Ctrl + E |
Remove scroll lock | ScrLk |
Remove duplicate | Alt + A + M |
Serial number | Alt + H + F + I + S |
Page break | Alt + P + B + I (ai) |