Excel keyboard shortcuts

The shortcuts worth knowing, grouped by what you are trying to do. Free, no sign-up.

Download the PDF (Windows and Mac)

Move around

Jump to the edge of the dataCtrl+Arrow key
Go to the first cell (A1)Ctrl+Home
Go to the last used cellCtrl+End
Go to the first cell of the rowHome
Scroll one screen down / upPage Down or Page Up
Scroll one screen right / leftAlt+Page Down or Alt+Page Up
Next / previous worksheetCtrl+Page Down or Ctrl+Page Up
Go to a cell or named rangeCtrl+G or F5
Move to the next / previous cell in a selectionTab or Shift+Tab
Search the sheetCtrl+F
Jump to the edge of the dataCmd+Arrow key
Go to the first cell (A1)Control+Home
Go to the last used cellControl+End
Go to the first cell of the rowHome
Scroll one screen down / upPage Down or Page Up
Scroll one screen right / leftOption+Page Down or Option+Page Up
Next / previous worksheetControl+Page Down or Control+Page Up
Go to a cell or named rangeControl+G
Move to the next / previous cell in a selectionTab or Shift+Tab
Search the sheetCmd+F

Select

Select the whole columnCtrl+Space
Select the whole rowShift+Space
Select everything (press again for the whole sheet)Ctrl+A
Extend the selection one cellShift+Arrow key
Extend the selection to the edge of the dataCtrl+Shift+Arrow key
Select the current regionCtrl+Shift+*
Extend the selection to the start of the sheetCtrl+Shift+Home
Extend the selection to the last used cellCtrl+Shift+End
Select only the visible cellsAlt+;
Select cells that differ in a rowCtrl+\
Select the whole columnControl+Space
Select the whole rowShift+Space
Select everything (press again for the whole sheet)Cmd+A
Extend the selection one cellShift+Arrow key
Extend the selection to the edge of the dataCmd+Shift+Arrow key
Select the current regionCmd+A
Extend the selection to the start of the sheetCmd+Shift+Home
Extend the selection to the last used cellCmd+Shift+End
Select only the visible cellsCmd+Shift+*
Select cells that differ in a rowControl+\

Edit a cell

Edit the active cellF2
Cancel what you are typingEsc
Start a new line inside a cellAlt+Enter
Delete the contents of the selectionDelete
Delete the character left of the cursorBackspace
UndoCtrl+Z
Redo / repeat the last actionCtrl+Y or F4
Insert the current dateCtrl+;
Insert the current timeCtrl+Shift+;
Add a note to a cellShift+F2
Edit the active cellF2
Cancel what you are typingEsc
Start a new line inside a cellControl+Option+Enter
Delete the contents of the selectionDelete
Delete the character left of the cursorDelete
UndoCmd+Z
Redo / repeat the last actionCmd+Y
Insert the current dateControl+;
Insert the current timeCmd+;
Add a note to a cellShift+F2

Copy, paste and fill

CopyCtrl+C
CutCtrl+X
PasteCtrl+V
Open Paste SpecialCtrl+Alt+V
Fill down from the cell aboveCtrl+D
Fill right from the cell on the leftCtrl+R
Fill the selected cells with the same entryCtrl+Enter
Flash FillCtrl+E
Copy the formula from the cell aboveCtrl+'
Copy the value from the cell aboveCtrl+Shift+"
CopyCmd+C
CutCmd+X
PasteCmd+V
Open Paste SpecialControl+Cmd+V
Fill down from the cell aboveControl+D
Fill right from the cell on the leftControl+R
Fill the selected cells with the same entryControl+Enter
Flash FillControl+E
Copy the formula from the cell aboveControl+'
Copy the value from the cell aboveControl+Shift+"

Format

Open the Format Cells boxCtrl+1
BoldCtrl+B
ItalicCtrl+I
UnderlineCtrl+U
StrikethroughCtrl+5
Number format with two decimalsCtrl+Shift+!
Currency formatCtrl+Shift+$
Percent formatCtrl+Shift+%
Date formatCtrl+Shift+#
Time formatCtrl+Shift+@
General number formatCtrl+Shift+~
Add an outline borderCtrl+Shift+&
Remove bordersCtrl+Shift+_
Center the cell contentsAlt+H, A, C
Open the Format Cells boxCmd+1
BoldCmd+B
ItalicCmd+I
UnderlineCmd+U
StrikethroughCmd+Shift+X
Number format with two decimalsControl+Shift+!
Currency formatControl+Shift+$
Percent formatControl+Shift+%
Date formatControl+Shift+#
Time formatControl+Shift+@
General number formatControl+Shift+~
Add an outline borderCmd+Option+0
Remove bordersCmd+Option+-

Formulas

Start a formula=
AutoSum the selected cellsAlt+=
Cycle between absolute and relative referencesF4
Show formulas instead of resultsCtrl+`
Calculate all open workbooksF9
Calculate the active sheetShift+F9
Open the function list while typingCtrl+A
Insert a function (Insert Function box)Shift+F3
Enter an array formula (older Excel)Ctrl+Shift+Enter
Expand or collapse the formula barCtrl+Shift+U
Start a formula=
AutoSum the selected cellsCmd+Shift+T
Cycle between absolute and relative referencesCmd+T
Show formulas instead of resultsControl+`
Calculate all open workbooksF9
Calculate the active sheetShift+F9
Open the function list while typingControl+A
Insert a function (Insert Function box)Shift+F3
Enter an array formula (older Excel)Cmd+Shift+Enter
Expand or collapse the formula barControl+Shift+U

Rows and columns

Insert cells, rows or columnsCtrl+Shift++
Delete cells, rows or columnsCtrl+-
Hide the selected rowsCtrl+9
Hide the selected columnsCtrl+0
Show hidden rowsCtrl+Shift+(
Show hidden columnsCtrl+Shift+)
Group the selected rows or columnsAlt+Shift+Right arrow
UngroupAlt+Shift+Left arrow
Insert cells, rows or columnsControl+Shift+=
Delete cells, rows or columnsCmd+-
Hide the selected rowsCmd+(
Hide the selected columnsCmd+)
Show hidden rowsCmd+Shift+(
Show hidden columnsCmd+Shift+)
Group the selected rows or columnsCmd+Shift+K
UngroupCmd+Shift+J

Data and tables

Turn filters on or offCtrl+Shift+L
Open a filter drop-downAlt+Down arrow
Create a tableCtrl+T or Ctrl+L
Insert a chart on a new sheetF11
Insert a chart on the current sheetAlt+F1
Open the Create Names from Selection boxCtrl+Shift+F3
Open the Name ManagerCtrl+F3
Open the Quick Analysis toolCtrl+Q
Open the Find and Replace boxCtrl+H
Turn filters on or offCmd+Shift+F
Open a filter drop-downOption+Down arrow
Create a tableControl+T
Insert a chart on a new sheetF11
Open the Create Names from Selection boxCmd+Shift+F3
Open the Find and Replace boxControl+H

Workbook and window

Create a new workbookCtrl+N
Open a workbookCtrl+O
SaveCtrl+S
Save AsF12
PrintCtrl+P
Close the workbookCtrl+W
Insert a new worksheetShift+F11
Switch to the next open workbookCtrl+Tab
Minimise the ribbonCtrl+F1
Show the ribbon keys (Key Tips)Alt
Check spellingF7
Create a new workbookCmd+N
Open a workbookCmd+O
SaveCmd+S
Save AsCmd+Shift+S
PrintCmd+P
Close the workbookCmd+W
Insert a new worksheetShift+F11
Switch to the next open workbookControl+Tab
Minimise the ribbonCmd+Option+R
Check spellingF7

Shortcuts are for current Excel for Microsoft 365. On a Mac, some keys also need the Fn key on laptops. Several of these are shown in our short videos on the Microsoft 365 Training channel.