How many keyboard shortcuts does Microsoft Excel have?

This page lists 80 shortcuts across 8 groups, covering the ones people actually use day to day rather than every binding the application defines.

Are Microsoft Excel shortcuts the same on Mac and Windows?

Mostly. The usual difference is that Ctrl on Windows becomes ⌘ on macOS, which is why the shortcuts here are written as "Ctrl/⌘". Where a binding genuinely differs beyond that swap, it is spelled out separately.

Microsoft Excel keyboard shortcuts

80 shortcuts

Windows, macOS and Linux

Microsoft Excel is the desktop spreadsheet. Its Windows and Mac builds diverge more than any other Office app: several Mac bindings keep the Control key instead of moving to Command, and a handful — absolute references, AutoSum, strikethrough, borders — are different keys entirely, so the Mac form is spelled out wherever it is not a plain Ctrl to Command swap.

Shortcut	What it does
Ctrl/⌘ + Arrow key	Jump to the edge of the data region
Home	Move to the beginning of the row
Ctrl + Home	Move to the beginning of the worksheet — On macOS: ⌃ + Home
Ctrl + End	Move to the last used cell on the worksheet — On macOS: ⌃ + End
Page Down	Move one screen down
Page Up	Move one screen up
Alt + Page Down	Move one screen to the right — On macOS: ⌥ + Page Down
Alt + Page Up	Move one screen to the left — On macOS: ⌥ + Page Up
F5	Open the Go To dialog — On macOS: ⌃ + G
Ctrl/⌘ + F	Open the Find dialog

Selection

Shortcut	What it does
Shift + Arrow key	Extend the selection by one cell
Ctrl/⌘ + Shift + Arrow key	Extend the selection to the last non-blank cell
Ctrl + Shift + Home	Extend the selection to the start of the worksheet — On macOS: ⌃ + ⇧ + Home
Ctrl + Shift + End	Extend the selection to the last used cell — On macOS: ⌃ + ⇧ + End
Ctrl + Spacebar	Select the entire column — On macOS: ⌃ + Space
Shift + Spacebar	Select the entire row
Ctrl/⌘ + A	Select the current region, then the whole worksheet
F8	Turn extend-selection mode on or off
Shift + F8	Add a non-adjacent range to the selection
Ctrl + Shift + Spacebar	Select every object on the worksheet — On macOS: ⌘ + ⇧ + Space

Editing and data entry

Shortcut	What it does
F2	Edit the active cell
Enter	Confirm the entry and move down
Shift + Enter	Confirm the entry and move up
Tab	Confirm the entry and move right
Shift + Tab	Confirm the entry and move left
Alt + Enter	Start a new line inside the same cell — On macOS: ⌥ + Return
Ctrl/⌘ + Enter	Fill every selected cell with the current entry
Esc	Cancel the cell entry
Delete	Clear the contents of the selected cells
Ctrl/⌘ + D	Fill down from the cell above
Ctrl/⌘ + R	Fill right from the cell to the left
Ctrl + E	Run Flash Fill — Not available in Excel for Mac
Ctrl/⌘ + Z	Undo the last action
Ctrl/⌘ + Y	Redo the last action

Formatting

Shortcut	What it does
Ctrl/⌘ + 1	Open the Format Cells dialog
Ctrl/⌘ + B	Apply or remove bold
Ctrl/⌘ + I	Apply or remove italic
Ctrl/⌘ + U	Apply or remove underline
Ctrl + 5	Apply or remove strikethrough — On macOS: ⌘ + ⇧ + X
Ctrl + Shift + $	Apply the Currency format — On macOS: ⌃ + ⇧ + $
Ctrl + Shift + %	Apply the Percentage format — On macOS: ⌃ + ⇧ + %
Ctrl + Shift + ~	Apply the General number format — On macOS: ⌃ + ⇧ + ~
Ctrl + Shift + #	Apply the Date format — On macOS: ⌃ + ⇧ + #
Ctrl + Shift + !	Apply the Number format with two decimals — On macOS: ⌃ + ⇧ + !
Ctrl + Shift + &	Apply an outline border — On macOS: ⌘ + ⌥ + 0
Ctrl + Shift + _	Remove the outline border — On macOS: ⌘ + ⌥ + -

Formulas and functions

Shortcut	What it does
F4	Cycle absolute and relative references — On macOS: ⌘ + T
Alt + =	Insert an AutoSum formula — On macOS: ⌘ + ⇧ + T
Ctrl + `	Show formulas instead of results — On macOS: ⌃ + `
Ctrl + Shift + Enter	Enter the formula as a legacy array formula — On macOS: ⌘ + ⇧ + Return
Ctrl + '	Copy the formula from the cell above — On macOS: ⌃ + '
Ctrl + Shift + "	Copy the value from the cell above — On macOS: ⌃ + ⇧ + "
F9	Recalculate every open workbook
Shift + F9	Recalculate the active worksheet
Shift + F3	Open the Insert Function dialog — On macOS this opens the Formula Builder
Ctrl + ;	Enter the current date
Ctrl + Shift + :	Enter the current time — On macOS: ⌘ + ;
Ctrl/⌘ + K	Insert a hyperlink

Rows, columns and sheets

Shortcut	What it does
Ctrl + Shift + +	Open the Insert cells dialog — On macOS: ⌃ + ⇧ + =
Ctrl + -	Open the Delete cells dialog — On macOS: ⌘ + -
Ctrl + 9	Hide the selected rows — On macOS: ⌃ + 9
Ctrl + 0	Hide the selected columns — On macOS: ⌃ + 0
Ctrl + Shift + (	Unhide the selected rows — On macOS: ⌃ + ⇧ + (
Ctrl + Shift + )	Unhide the selected columns — On macOS: ⌃ + ⇧ + )
Shift + F11	Insert a new worksheet
Ctrl + Page Down	Go to the next worksheet
Ctrl + Page Up	Go to the previous worksheet
Ctrl + 8	Show or hide outline symbols — On macOS: ⌃ + 8

Data and analysis

Shortcut	What it does
Ctrl + Shift + L	Turn AutoFilter on or off — On macOS: ⌘ + ⇧ + F
Alt + Down Arrow	Open the filter or validation drop-down for the cell — On macOS: ⌥ + ↓
Ctrl + Q	Show Quick Analysis options for the selection — Not available in Excel for Mac
Ctrl + Shift + G	Open the Workbook Statistics dialog
F11	Chart the selected data on a new sheet
Alt + F11	Open the Visual Basic Editor — On macOS: ⌥ + F11

File and view

Shortcut	What it does
Ctrl/⌘ + S	Save the workbook
Ctrl/⌘ + O	Open a workbook
Ctrl/⌘ + N	Create a new blank workbook
Ctrl/⌘ + P	Print the workbook
Ctrl/⌘ + W	Close the active workbook window
Ctrl + F1	Show or hide the ribbon — On macOS: ⌘ + ⌥ + R

Common questions

How many keyboard shortcuts does Microsoft Excel have?: This page lists 80 shortcuts across 8 groups, covering the ones people actually use day to day rather than every binding the application defines.
Are Microsoft Excel shortcuts the same on Mac and Windows?: Mostly. The usual difference is that Ctrl on Windows becomes ⌘ on macOS, which is why the shortcuts here are written as "Ctrl/⌘". Where a binding genuinely differs beyond that swap, it is spelled out separately.

Sources

Official vendor product documentation — At One Place

How these figures are compiled and checked