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