Excel Hack

All shortcut keys for Excel

For ease of viewing, shortcut keys for Excel for Windows are listed by usage. Clicking on the To do this link will take you to a detailed page of the selected content.

Shortcut keys for Excel for Mac are available on a separate page.

Excel shortcuts for Mac

Windows shortcut key list

To do thisWindows key
Fill downCtrl + D
Insert cellsCtrl + Shift + + (plus)
Insert cut cellsCtrl + Shift + + (plus)
Cut valueCtrl + X
Delete the characters of the active cellBackspace
Delete character to the leftBackspace
Delete character to the rightDelete
Delete characters to the end of the lineCtrl + Delete
Shift cells upCtrl + – (minus)
Open fileCtrl + O
Open dialog boxCtrl + F12
Hide windowAlt + W + H
Unhide windowAlt + W + U
Close ExcelAlt + F4
Close active bookCtrl + W
Row
Insert rowCtrl + Shift + + (plus)
Insert multiple rowsCtrl + Shift + + (plus)
Insert row aboveCtrl + Shift + + (plus)
Insert row belowAssigning shortcut keys to VBA
Delete rowCtrl + – (minus)
Delete blank rowCtrl + – (minus)
Get the bottom of current rowCtrl + ↓ (down arrow key)
Select by one cell to the left or rightShift + ← (left arrow)
Shift + → (right arrow)
Select entire rowShift + Space
Extend select to start of rowShift + Home
Extend select to end of rowCtrl + Shift + → (right arrow)
Row heightAlt + H + O + H
AutoFit rowAlt + H + O + A
Hide rowCtrl + 9
Unhide rowCtrl + Shift + 9
Freeze top rowAlt + W + F + R
Freeze multiple rowsAlt + W + F + F
Highlight rowShift + Space
Alt + H + H
Column
Insert columnCtrl + Shift + + (plus)
Delete columnCtrl + – (minus)
Select by one cell to the above or belowShift + ↑ (up arrow key)
Shift + ↓ (down arrow key)
Select entire columnCtrl + Space
Select to end of columnCtrl + Shift + ↓ (down arrow)
Select entire column with dataCtrl + Shift + ↑ (up arrow)
Ctrl + Shift + ↓ (down arrow)
Column selection by one screenShift + PgUp
Shift + PgDn
Select cells that do not match the active cellCtrl + Shift + | (vertical bar)
AutoFit columnAlt + H + O + I (ai)
Set the value for column widthAlt + H + O + W
Copy only column width to another columnCtrl + Alt + V, W
Hide columnCtrl + 0 (zero)
Unhide columnAlt + H + O + U + L
Unhide data in the same columnAlt + ↓ (down arrow key)
Freeze the first columnAlt + W + F + C
Freeze columns and rows in any cellAlt + W + F + F
Highlight entire columnCtrl + Space
Alt + H + H
Text to columnAlt + A + E
Sheet
New sheetShift + F11
Select entire sheetCtrl + A
Select the current and previous sheetCtrl + Shift + PgUp
Select the current and next sheetCtrl + Shift + PgDn
Switch sheetCtrl + PgUp
Ctrl + PgDn
Next sheetCtrl + PgDn
Move sheetAlt + E + M
Copy sheetAlt + E + M
Rename sheetAlt + H + O + R
Sheet tab color changeAlt + H + O + T
Protect SheetAlt + R + P + S
Delete sheetAlt + E + L
Close only one sheetAlt + E + L
Close all sheetsCtrl + W
Move
Move to other cells↑ or ↓ or → or ← (Arrow key)
Move to the cell on the edge of the dataCtrl + ↑ or ↓ or → or ← (Arrow key)
Format
boldCtrl + B
StrikethroughCtrl + 5
Left alignmentAlt + H + A + L
Center alignmentAlt + H + A + C
Right alignmentAlt + H + A + R
Top alignmentAlt + H + A + T
Middle alignmentAlt + H + A + M
Bottom alignmentAlt + H + A + B
Copy formatAlt + H + F + P
Format painterAlt + H + F + P
Format cellCtrl + 1
Font tabCtrl + Shift + P
Increase font sizeAlt + H + F + G
Set any font sizeCtrl + Shift + F
All borderAlt + H + B + A
Bottom borderAlt + H + B + O
Top borderAlt + H + B + P
Left borderAlt + H + B + L
Right borderAlt + H + B + R
No borderAlt + H + B + N
Outside borderAlt + H + B + S
Thick outside borderAlt + H + B + T
Bottom double borderAlt + H + B + B
Thick bottom borderAlt + H + B + H
Top and bottom borderAlt + H + B + D
Wrap textAlt + H + W
Number formatCtrl + Shift + 1
Time formatCtrl + Shift + @
Current timeCtrl + Shift + : (colon)
Date FormatCtrl + Shift + #
Today’s dateCtrl + ; (semicolon)
Apply currency formatCtrl + Shift + $
Apply percentage formatCtrl + Shift + %
Apply scientific formatCtrl + Shift + ^ (caret)
Apply general formatCtrl + Shift + ~ (tilde)
Up and Down ArrowsAlt + H + L + I (ai), Enter
New Formatting RuleAlt + H + L + N
Top/Bottom rulesAlt + H + L + T
Merge cellAlt+ H + M + M
Merge and centerAlt + H + M + C
Merge cells horizontally onlyAlt + H + M + A
Unmerge cellAlt + H + M + U
Highlight cells rulesAlt + H + L + H
Highlight cells yellowAlt + H + H
Data barsAlt + H + L + D
Color paletteAlt + H + H
Colors dialog boxAlt + H + H + M
Color scalesAlt + H + L + S
Conditional Formatting Rules ManagerAlt + O + D
SuperscriptCtrl + Shift + P
SubscriptCtrl + Shift + P
Format Cells dialog boxCtrl + 1
Symbol dialog boxAlt + N + Z + S + U
Formula/Function
Cursor to formula barF2
Setup required
Edit formulaF2
Drag formulaCtrl + Enter
Formula bar widerCtrl + Shift + U
Show formulaCtrl+ Shift + ` (grave accent)
Show all formulaAlt + M + H
Copy formula downCtrl + D
Multiply formulaCtrl + Alt + V, M
Remove formulaCtrl + Alt + V, V
Absolute referenceF4
Insert argument names into formulaCtrl + Shift + A
Select cells that are directly referenced in a formulaCtrl + [
Select cells with formulas that directly reference the cellCtrl + ]
Insert functionShift + F3
Calculate sumAlt + H + U + S
AutoSumAlt + =
SubtotalAlt + A + B
Calculate averageAlt + M + U + A
Absolute valueAlt + M + G
Pivot table
PivotTableAlt + N + V + T
PivotTable & PivotChart WizardAlt + D + P
Update a specific pivot tableAlt + F5
Update all pivot tablesCtrl + Alt + F5
Macro/VBA
Open the MacroAlt + F8
Open VBAAlt + F11
Others
Select all cells from the current cell to A1Ctrl + Shift + Home
Select only the active cell when multiple cells are selectedShift + Backspace
First letter capitalAlt + M + T
Small letterAlt + M + T
capital lettersAlt + M + T
Hide ribbonCtrl + F1
Unhide ribbonCtrl + F1
Get the bottom cellCtrl + End
SearchCtrl + F
Find nextShift + F4
Find previousCtrl + Shift + F4
Go to a specific cellF5
Remove newlineCtrl + H
Operation required
Select all cells with NotesCtrl + Shift + O
Insert notesShift + F2
Insert commentCtrl +Shift + F2
Delete commentAlt + R + D
Data validationAlt + D + L
Hide objectCtrl + 6
Flash fillCtrl + E
Remove scroll lockScrLk
Remove duplicateAlt + A + M
Serial numberAlt + H + F + I + S
Page breakAlt + P + B + I (ai)