Pro Templates

Excel Shortcuts

Search and filter all relevant Excel shortcuts in seconds.
Use the Highlight filter to extract the most helpful fundamental and advanced shortcuts.

ShortcutWindowsMac OS
General
CopyCtrl C⌘ C
CutCtrl X⌘ X
PasteCtrl V⌘ V
Paste SpecialCtrl Alt V⌘ Ctrl V
Display FindCtrl F⌘ F
Display Find and ReplaceCtrl H⌘ H
Undo Last ActionCtrl Z⌘ Z
Redo Last ActionCtrl Y⌘ Y
Open OptionsAlt F T⌘ ,
Open HelpF1⌘ /
File
Create New WorkbookCtrl N⌘ N
Open WorkbookCtrl O⌘ O
Save WorkbookCtrl S⌘ S
Save Workbook AsF12⌘ ⇧ S
Print FileCtrl P⌘ P
Close Current WorkbookCtrl F4⌘ W
Close ExcelAlt F4⌘ Q
Workbook
Insert New Worksheet⇧ F11fn ⇧ F11
Go To Next WorksheetCtrl PgDnfn Ctrl ↓
Go To Previous WorksheetCtrl PgUpfn Ctrl ↑
Go To Next PaneF6fn F6
Go To Previous Pane⇧ F6fn ⇧ F6
Go To Next WorkbookCtrl TabCtrl Tab
Go To Previous WorkbookCtrl ⇧ TabCtrl ⇧ Tab
Minimise Current Workbook WindowCtrl F9⌘ M
Maximise Current Workbook WindowCtrl F10fn ⇧ F10
Toggle Scroll LockScrLkfn ⇧ F14
Toggle Full ScreenCtrl ⇧ F1Ctrl ⌘ F
Grid Operations
Insert Rows/ColumnsCtrl ⇧ +Ctrl ⇧ =
Delete Rows/ColumnsCtrl -Ctrl -
Delete CellsCtrl -Ctrl -
Delete Content of Selected CellsDeletefn Delete
Hide ColumnsCtrl 0Ctrl 0
Hide RowsCtrl 9Ctrl 9
Unhide ColumnsCtrl ⇧ 0Ctrl ⇧ 0
Unhide RowsCtrl ⇧ 9Ctrl ⇧ 9
Group Rows/ColumnsAlt ⇧ →⌘ ⇧ K
Ungroup Rows/ColumnsAlt ⇧ ←⌘ ⇧ J
Hide/Show Outline (Group) SymbolsCtrl 8Ctrl 8
Zoom InCtrl Alt +
Zoom OutCtrl Alt -
Navigation
Move to Right Edge of Data RegionCtrl →Ctrl →
Move to Left Edge of Data RegionCtrl ←Ctrl ←
Move to Top Edge of Data RegionCtrl ↑Ctrl ↑
Move to Bottom Edge of Data RegionCtrl ↓Ctrl ↓
Move One Screen RightAlt PgDnFn ⌥ ↓
Move One Screen LeftAlt PgUpFn ⌥ ↑
Move One Screen UpPgUpFn ↑
Move One Screen DownPgDnFn ↓
Move to First Cell in WorksheetCtrl HomeFn Ctrl ←
Move to Last Cell in WorksheetCtrl EndFn Ctrl →
Move to Beginning of the RowHomeFn ←
Turn End Mode OnEndFn →
Selection
Select Entire WorksheetCtrl A⌘ A
Select Entire Row⇧ Space⇧ Space
Select Entire ColumnCtrl SpaceCtrl Space
Select Adjacent Cells to Selection⇧ Click⇧ Click
Select Non-Adjacent Cells to SelectionCtrl ClickCtrl Click
Move Right Between Non-Adjacent SelectionsCtrl Alt →Ctrl ⌥ →
Move Left Between Non-Adjacent SelectionsCtrl Alt ←Ctrl ⌥ ←
Move Active Cell Right in SelectionTabTab
Move Active Cell Left in Selection⇧ Tab⇧ Tab
Move Active Cell Up in SelectionEnterReturn
Move Active Cell Down in Selection⇧ Enter⇧ Return
Toggle Add to Selection Mode⇧ F8Fn ⇧ F8
Cancel SelectionEscEsc
Extend Selection
Extend Selection by One Cell Right⇧ →⇧ →
Extend Selection by One Cell Left⇧ ←⇧ ←
Extend Selection by One Cell Up⇧ ↑⇧ ↑
Extend Selection by One Cell Down⇧ ↓⇧ ↓
Extend Selection to the Last Cell RightCtrl ⇧ →Ctrl ⇧ →
Extend Selection to the Last Cell LeftCtrl ⇧ ←Ctrl ⇧ ←
Extend Selection to the Last Cell UpCtrl ⇧ ↑Ctrl ⇧ ↑
Extend Selection to the Last Cell DownCtrl ⇧ ↓Ctrl ⇧ ↓
Extend Selection Right One ScreenAlt ⇧ PgDnFn ⇧ ⌘ ↓
Extend Selection Left One ScreenAlt ⇧ PgUpFn ⇧ ⌘ ↑
Extend Selection Up One Screen⇧ PgUpFn ⇧ ↑
Extend Selection Down One Screen⇧ PgDnFn ⇧ ↓
Extend Selection to Start of Row⇧ HomeFn ⇧ ←
Extend Selection to First Cell in WorksheetCtrl ⇧ HomeFn Ctrl ⇧ ←
Extend Selection to Last Cell in WorksheetCtrl ⇧ EndFn Ctrl ⇧ →
Toggle Extend Selection ModeF8Fn F8
Special Selection
Select Current RegionCtrl A⌘ A
Select Cells with CommentsCtrl ⇧ OFn Ctrl ⇧ O
Select Current ArrayCtrl /Ctrl /
Select Row DifferencesCtrl \Ctrl \
Select Column DifferencesCtrl ⇧ |Ctrl ⇧ |
Select Direct PrecedentsCtrl [Ctrl [
Select All PrecedentsCtrl ⇧ {Ctrl ⇧ {
Select Direct DependentsCtrl ]Ctrl ]
Select All DependentsCtrl ⇧ }Ctrl ⇧ }
Select Visible Cells OnlyAlt ;Alt ;
Display Go To Dialog BoxCtrl GCtrl G
Cell Editing
Edit Active CellF2Ctrl U
Insert Edit Comment⇧ F2fn ⇧ F2
Cancel EditEscEsc
Select One Character Right⇧ →⇧ →
Select One Character Left⇧ ←⇧ ←
Move One Word RightCtrl →Ctrl →
Move One Word LeftCtrl ←Ctrl ←
Select One Word RightCtrl ⇧ →Ctrl ⇧ →
Select One Word LeftCtrl ⇧ ←Ctrl ⇧ ←
Select Beginning of Cell⇧ HomeFn ⇧ ←
Select End of Cell⇧ EndFn ⇧ →
Delete to End of LineCtrl DeleteCtrl Delete
Delete Character to the Left of CursorBackspaceDelete
Delete Character to the Right of CursorDeleteFn Delete
Start a New Line in the Same CellAlt Enter⇧ ⌥ Return
Enter and Move DownEnterReturn
Enter and Move Up⇧ Enter⇧ Return
Enter and Move RightTabTab
Enter and Move Left⇧ Tab⇧ Tab
Enter and Stay in the Same CellCtrl EnterCtrl Return
Special Inserting
Insert DateCtrl ⇧ ;Ctrl ⇧ ;
Insert TimeCtrl ⇧ :⌘ ⇧ :
Fill Down From Cell AboveCtrl DCtrl D
Fill Right From Cell LeftCtrl RCtrl R
Add HyperlinkCtrl KCtrl K
Display Auto-Complete ListAlt ↓⌥ ↓
Flash FillCtrl E
General Formatting
Open Format Cell DialogCtrl 1⌘ 1
Apply/Remove Bold FormattingCtrl B⌘ B
Apply/Remove Italic FormattingCtrl I⌘ I
Apply/Remove Underscoring FormattingCtrl U⌘ U
Apply/Remove Strikethrough FormattingCtrl 5⌘ ⇧ X
Align CenterAlt H A C⌘ E
Align RightAlt H A R⌘ R
Align LeftAlt H A L⌘ L
Add IndentAlt H 6Ctrl ⌥ Tab
Remove IndentAlt H 5Ctrl ⇧ ⌥ Tab
Number Formatting
Apply General FormatCtrl ⇧ ~Ctrl ⇧ ~
Apply Currency FormatCtrl ⇧ $Ctrl ⇧ $
Apply Percentage FormatCtrl ⇧ %Ctrl ⇧ %
Apply Scientific FormatCtrl ⇧ ^Ctrl ⇧ ^
Apply Date FormatCtrl ⇧ #Ctrl ⇧ #
Apply Time FormatCtrl ⇧ @Ctrl ⇧ @
Apply Number FormatCtrl ⇧ !Ctrl ⇧ !
Border Formatting
Add Border OutlineCtrl ⇧ &⌘ ⌥ 0
Add/Remove Border RightAlt R⌘ ⌥ →
Add/Remove Border LeftAlt L⌘ ⌥ ←
Add/Remove Border TopAlt T⌘ ⌥ ↑
Add/Remove Border BottomAlt B⌘ ⌥ ↓
Add/Remove Border Upward DiagonalAlt D—
Add/Remove Border Horizontal InteriorAlt H—
Add/Remove Border Vertical InteriorAlt V—
Remove BordersCtrl ⇧ _⌘ ⌥ _
Formulas
Toggle Absolute and Relative ReferencesF4⌘ T
Open the Insert Function Dialog Box⇧ F3fn ⇧ F3
Autosum Selected CellsAlt =⌘ ⇧ T
Toggle Formulas On and OffCtrl 'Ctrl '
Insert Function ArgumentsCtrl ⇧ ACtrl ⇧ A
Enter Array FormulaCtrl ⇧ EnterCtrl ⇧ Return
Calculate All WorksheetsF9fn F9
Calculate Active Worksheet⇧ F9fn ⇧ F9
Evaluate FormulaF9fn F9
Hide/Show Formula BarCtrl ⇧ UCtrl ⇧ U
Define NameCtrl F3fn Ctrl F3
Define Name For Columns/RowsCtrl ⇧ F3fn Ctrl ⇧ F3
Paste Name into FormulaF3F3
Accept Autocomplete FunctionTab Tab
Tables & Filters
Insert TableCtrl TCtrl T
Activate FilterAlt ↓⌥ ↓
Select Table Row⇧ Space⇧ Space
Select Table ColumnCtrl SpaceCtrl Space
Select Entire TableCtrl ACtrl A
Clear Slicer FilterAlt C⌥ C
Toggle AutofilterCtrl ⇧ L⌘ ⇧ F
Toggle Table Total RowCtrl ⇧ T⌘ ⇧ T