Search shortcuts instantly
Need a shortcut by task instead? Use the AI-powered Excel Shortcut Finder to search in plain English.
Open Shortcut FinderBasics
BasicsCopyWin: Ctrl + C · Mac: Cmd + C
BasicsCutWin: Ctrl + X · Mac: Cmd + X
BasicsPasteWin: Ctrl + V · Mac: Cmd + V
BasicsUndoWin: Ctrl + Z · Mac: Cmd + Z
BasicsRedoWin: Ctrl + Y · Mac: Cmd + Shift + Z
BasicsSaveWin: Ctrl + S · Mac: Cmd + S
BasicsSave AsWin: F12 · Mac: Cmd + Shift + S
BasicsNew workbookWin: Ctrl + N · Mac: Cmd + N
BasicsOpen fileWin: Ctrl + O · Mac: Cmd + O
BasicsClose workbookWin: Ctrl + W · Mac: Cmd + W
BasicsPrintWin: Ctrl + P · Mac: Cmd + P
BasicsSelect allWin: Ctrl + A · Mac: Cmd + A
BasicsFindWin: Ctrl + F · Mac: Cmd + F
BasicsSpell checkWin: F7 · Mac: F7
Cell Editing
Cell EditingEdit cell (enter edit mode)Win: F2 · Mac: F2
Cell EditingDelete cell contentWin: Delete · Mac: Delete
Cell EditingClear all (content + formatting)Win: Alt → H → E → A · Mac: No direct shortcut
Cell EditingFill DownWin: Ctrl + D · Mac: Cmd + D
Cell EditingFill RightWin: Ctrl + R · Mac: Cmd + R
Cell EditingFill series (AutoFill)Win: Alt → H → FI → S · Mac: No direct shortcut
Cell EditingCell line breakWin: Alt + Enter · Mac: Ctrl + Option + Enter
Cell EditingFill same value into multiple cellsWin: Ctrl + Enter · Mac: Cmd + Enter
Cell EditingRepeat last actionWin: F4 / Ctrl + Y · Mac: Cmd + Y
Cell EditingAdd comment / noteWin: Shift + F2 · Mac: Fn + Shift + F2
Data
DataToggle AutoFilterWin: Ctrl + Shift + L · Mac: Cmd + Shift + F
DataInsert current dateWin: Ctrl + ; · Mac: Ctrl + ;
DataInsert current timeWin: Ctrl + Shift + ; · Mac: Ctrl + Shift + ;
DataRemove duplicatesWin: Alt → A → M · Mac: No direct shortcut
DataCreate pivot tableWin: Alt → N → V → T · Mac: No direct shortcut
DataFind & ReplaceWin: Ctrl + H · Mac: Cmd + H
DataFlash FillWin: Ctrl + E · Mac: Cmd + E
DataSort A to ZWin: Alt → A → S → A · Mac: No direct shortcut
DataText to columnsWin: Alt → A → E · Mac: No direct shortcut
DataPaste values onlyWin: Ctrl + Alt + V → V → Enter · Mac: Cmd + Ctrl + V → V → Enter
Formatting
FormattingBoldWin: Ctrl + B · Mac: Cmd + B
FormattingItalicWin: Ctrl + I · Mac: Cmd + I
FormattingUnderlineWin: Ctrl + U · Mac: Cmd + U
FormattingPaste SpecialWin: Ctrl + Alt + V · Mac: Cmd + Ctrl + V
FormattingFormat cells dialogWin: Ctrl + 1 · Mac: Cmd + 1
FormattingWrap textWin: Alt → H → W · Mac: No direct shortcut
FormattingMerge & centerWin: Alt → H → M → C · Mac: No direct shortcut
FormattingApply currency formatWin: Ctrl + Shift + $ · Mac: Cmd + Shift + $
FormattingApply percentage formatWin: Ctrl + Shift + % · Mac: Cmd + Shift + %
FormattingConditional formattingWin: Alt → H → L · Mac: No direct shortcut
Navigation
NavigationSelect entire columnWin: Ctrl + Space · Mac: Ctrl + Space
NavigationSelect entire rowWin: Shift + Space · Mac: Shift + Space
NavigationSelect all cellsWin: Ctrl + A · Mac: Cmd + A
NavigationGo To SpecialWin: Ctrl + G → Alt + S · Mac: Cmd + G → S
NavigationJump to last used cell in row/columnWin: Ctrl + Arrow key · Mac: Cmd + Arrow key
NavigationMove to next sheetWin: Ctrl + Page Down · Mac: Fn + Ctrl + Down
NavigationMove to previous sheetWin: Ctrl + Page Up · Mac: Fn + Ctrl + Up
NavigationNew sheetWin: Shift + F11 · Mac: Fn + Shift + F11
Formulas
FormulasLock cell reference ($)Win: F4 · Mac: Cmd + T
FormulasAutoSum selected rangeWin: Alt + = · Mac: Cmd + Shift + T
FormulasEvaluate formulaWin: Alt → M → V · Mac: No direct shortcut
FormulasShow formulasWin: Ctrl + ` · Mac: Ctrl + `
FormulasTrace dependentsWin: Ctrl + ] · Mac: Ctrl + ]
FormulasRecalculate all formulasWin: F9 · Mac: F9
View
ViewFreeze panesWin: Alt → W → F → F · Mac: No direct shortcut
ViewSplit windowWin: Alt → W → S · Mac: No direct shortcut
ViewZoom inWin: Ctrl + Mouse scroll up · Mac: Cmd + Mouse scroll up
ViewZoom outWin: Ctrl + Mouse scroll down · Mac: Cmd + Mouse scroll down
ViewHide rowWin: Ctrl + 9 · Mac: Cmd + 9
ViewHide columnWin: Ctrl + 0 · Mac: Cmd + 0
ViewGroup rowsWin: Alt + Shift + → · Mac: Cmd + Shift + K
Insert & Delete
Insert & DeleteInsert rowWin: Ctrl + Shift + + · Mac: Cmd + Shift + +
Insert & DeleteDelete rowWin: Ctrl + - · Mac: Cmd + -
Insert & DeleteInsert columnWin: Ctrl + Shift + + · Mac: Cmd + Shift + +
Insert & DeleteDelete columnWin: Ctrl + - · Mac: Cmd + -
Insert & DeleteInsert cells / shift downWin: Ctrl + Shift + + · Mac: Cmd + Shift + +
Insert & DeleteDelete cells / shift upWin: Ctrl + - · Mac: Cmd + -
Insert & DeleteInsert new sheetWin: Shift + F11 · Mac: Fn + Shift + F11
Insert & DeleteDelete sheetWin: Alt → H → D → S · Mac: No direct shortcut
Insert & DeleteRename sheetWin: Alt → H → O → R · Mac: Double-click tab
Insert & DeleteInsert hyperlinkWin: Ctrl + K · Mac: Cmd + K