Excel shortcut keys for Windows and Mac

Common workbook actions

Save, open, close, print, edit, and reach the most-used Excel commands from either desktop platform.

Action	Shortcuts
Save the workbook	Windows`Ctrl` + `S` macOS`Cmd` + `S`
Open a workbook	Windows`Ctrl` + `O` macOS`Cmd` + `O`
Close the active workbook window	Windows`Ctrl` + `W` macOS`Cmd` + `W`
Quit ExcelThe Excel reference lists Cmd+Q for Mac; close Excel on Windows with Alt+F4.	WindowsNot documented macOS`Cmd` + `Q`
Open Save As	Windows`F12` macOS`Cmd` + `Shift` + `S`
Print the workbook	Windows`Ctrl` + `P` macOS`Cmd` + `P`
Copy the selection	Windows`Ctrl` + `C` macOS`Cmd` + `C`
Cut the selection	Windows`Ctrl` + `X` macOS`Cmd` + `X`
Paste the selection	Windows`Ctrl` + `V` macOS`Cmd` + `V`
Undo the last action	Windows`Ctrl` + `Z` macOS`Cmd` + `Z`
Redo the last actionCmd+Shift+Z is also documented on Mac.	Windows`Ctrl` + `Y` macOS`Cmd` + `Y`
Remove cell contents	Windows / macOS`Delete`
Open Find	Windows`Ctrl` + `F` macOS`Cmd` + `F`
Open Replace	Windows`Ctrl` + `H` macOS`Cmd` + `Shift` + `H`
Open Format Cells	Windows`Ctrl` + `1` macOS`Cmd` + `1`
Select the current region or worksheetPress again to extend the selection; Cmd+Shift+Space is also documented on Mac.	Windows`Ctrl` + `A` macOS`Cmd` + `A`
Open the context menuThe Mac reference also lists Shift+F10.	Windows`Shift` + `F10` macOSNot documented

Ribbon and command access

Use Key Tips and focus movement to reach Excel commands without scanning the ribbon with a mouse.

Action	Shortcuts
Activate ribbon Key TipsF10 is an alternative on Windows.	Windows`Alt` macOSNot documented
Move to the Search field	Windows`Alt` + `Q` macOSNot documented
Open the File tab	Windows`Alt` + `F` macOSNot documented
Open the Home tab	Windows`Alt` + `H` macOSNot documented
Open the Insert tab	Windows`Alt` + `N` macOSNot documented
Open the Page Layout tab	Windows`Alt` + `P` macOSNot documented
Open the Formulas tab	Windows`Alt` + `M` macOSNot documented
Open the Data tab	Windows`Alt` + `A` macOSNot documented
Open the Review tab	Windows`Alt` + `R` macOSNot documented
Open the View tab	Windows`Alt` + `W` macOSNot documented
Move to the next ribbon command	Windows`Tab` macOSNot documented
Move to the previous ribbon command	Windows`Shift` + `Tab` macOSNot documented
Show the focused ribbon tooltip	Windows`Ctrl` + `Shift` + `F10` macOSNot documented
Expand or collapse the ribbon	Windows`Ctrl` + `F1` macOS`Cmd` + `Option` + `R`
Activate the focused ribbon commandEnter is also documented.	Windows`Space` macOSNot documented

Move across a worksheet, jump to the data edge or a specific cell, switch sheets, and navigate screen-sized ranges.

Action	Shortcuts
Move one cell up	Windows / macOS`Up`
Move one cell down	Windows / macOS`Down`
Move one cell left	Windows / macOS`Left`
Move one cell right	Windows / macOS`Right`
Move to the edge of the current data region	Windows`Ctrl` + `Arrow` macOS`Cmd` + `Arrow`
Move to the beginning of the worksheet	Windows / macOS`Ctrl` + `Home`
Move to the last used cell	Windows / macOS`Ctrl` + `End`
Move one screen down	Windows / macOS`Page Down`
Move one screen up	Windows / macOS`Page Up`
Move one screen right	Windows`Alt` + `Page Down` macOS`Option` + `Page Down`
Move one screen left	Windows`Alt` + `Page Up` macOS`Option` + `Page Up`
Move to the next worksheetOption+Right also moves to the next sheet on Mac.	Windows / macOS`Ctrl` + `Page Down`
Move to the previous worksheetOption+Left also moves to the previous sheet on Mac.	Windows / macOS`Ctrl` + `Page Up`
Move right or between unlocked cells	Windows / macOS`Tab`
Move to the previous cell	Windows / macOS`Shift` + `Tab`
Open a cell validation list	Windows`Alt` + `Down` macOS`Option` + `Down`
Open the Go To dialog	Windows`F5` macOS`Ctrl` + `G`
Zoom in	Windows / macOS`Ctrl` + `Alt` + `=`
Zoom out	Windows / macOS`Ctrl` + `Alt` + `-`

Selection and cell entry

Extend or add to selections, enter values across a range, insert line breaks, and cancel or complete a cell entry.

Action	Shortcuts
Select the entire row	Windows / macOS`Shift` + `Space`
Select the entire column	Windows / macOS`Ctrl` + `Space`
Extend the selection by one cell	Windows / macOS`Shift` + `Arrow`
Extend the selection to the data edge	Windows / macOS`Ctrl` + `Shift` + `Arrow`
Turn Extend mode on or offThe Mac reference also lists F8.	Windows`F8` macOSNot documented
Add a non-adjacent range to the selectionThe Mac reference also lists Shift+F8.	Windows`Shift` + `F8` macOSNot documented
Insert a line break in the same cell	Windows`Alt` + `Enter` macOS`Cmd` + `Option` + `Return`
Fill the selected range with the current entry	Windows`Ctrl` + `Enter` macOS`Cmd` + `Return`
Complete entry and select the cell above	Windows`Shift` + `Enter` macOS`Shift` + `Return`
Edit the active cell	Windows / macOS`F2`
Cancel a cell or formula-bar entry	Windows / macOS`Esc`
Complete a cell entry	Windows`Enter` macOS`Return`
Select the current data regionCmd+Shift+* is also documented on Mac.	Windows`Ctrl` + `Shift` + `*` macOSNot documented
Select the entire worksheet	Windows`Ctrl` + `Shift` + `Space` macOS`Cmd` + `Shift` + `Space`

Formatting and cell commands

Format text and numbers, set borders, create tables, and reach the dialogs that change how a selection behaves.

Action	Shortcuts
Toggle bold	Windows`Ctrl` + `B` macOS`Cmd` + `B`
Toggle italic	Windows`Ctrl` + `I` macOS`Cmd` + `I`
Toggle underline	Windows`Ctrl` + `U` macOS`Cmd` + `U`
Toggle strikethroughCmd+5 is also listed for Mac.	Windows`Ctrl` + `5` macOSNot documented
Apply the General number format	Windows`Ctrl` + `Shift` + `~` macOSNot documented
Apply the Currency format	Windows`Ctrl` + `Shift` + `$` macOSNot documented
Apply the Percentage format	Windows`Ctrl` + `Shift` + `%` macOSNot documented
Apply the Date format	Windows`Ctrl` + `Shift` + `#` macOSNot documented
Apply the Time format	Windows`Ctrl` + `Shift` + `@` macOSNot documented
Apply an outline borderCmd+Option+0 is the Mac binding.	Windows`Ctrl` + `Shift` + `&` macOSNot documented
Remove the outline borderCmd+Option+- is the Mac binding.	Windows`Ctrl` + `Shift` + `_` macOSNot documented
Show values or formulas	Windows / macOS`Ctrl` + `
Fill down	Windows`Ctrl` + `D` macOS`Cmd` + `D`
Fill right	Windows`Ctrl` + `R` macOS`Cmd` + `R`
Open the Insert Cells dialogThe Mac reference uses Ctrl+Shift+=.	Windows`Ctrl` + `Shift` + `+` macOSNot documented
Open the Delete Cells dialog	Windows`Ctrl` + `-` macOS`Cmd` + `-`
Open Insert Hyperlink	Windows`Ctrl` + `K` macOS`Cmd` + `K`
Open Create Table	Windows`Ctrl` + `T` macOS`Cmd` + `T`
Show Quick Analysis optionsThe Mac source does not list a separate equivalent in this section.	Windows`Ctrl` + `Q` macOSNot documented

Data, formulas, and refresh

Enter formulas, calculate workbooks, use Flash Fill, insert functions, refresh external data, and open the main Excel data tools.

Action	Shortcuts
Enter the current date	Windows / macOS`Ctrl` + `;`
Enter the current time	Windows`Ctrl` + `Shift` + `;` macOS`Cmd` + `;`
Insert an AutoSum formula	Windows`Alt` + `=` macOS`Shift` + `Cmd` + `T`
Open Insert Function or Formula Builder	Windows / macOS`Shift` + `F3`
Expand or collapse the formula bar	Windows / macOS`Ctrl` + `Shift` + `U`
Show formula tooltips	Windows`Ctrl` + `Alt` + `P` macOS`Ctrl` + `Option` + `P`
Invoke Flash Fill	Windows`Ctrl` + `E` macOSNot documented
Cycle absolute and relative references	Windows / macOS`F4`
Calculate all open workbooks	Windows`F9` macOS`Cmd` + `=`
Calculate the active worksheet	Windows / macOS`Shift` + `F9`
Force a full calculation	Windows`Ctrl` + `Alt` + `F9` macOSNot documented
Create an embedded chartF11 creates a chart sheet.	Windows`Alt` + `F1` macOSNot documented
Open the Macro dialog	Windows`Alt` + `F8` macOS`Option` + `F8`
Open the Visual Basic editor	Windows`Alt` + `F11` macOS`Option` + `F11`
Open Power Query Editor	Windows`Alt` + `F12` macOS`Option` + `F12`
Refresh data in the current worksheet	Windows`Ctrl` + `F5` macOSNot documented
Refresh all workbook data	Windows`Ctrl` + `Alt` + `F5` macOSNot documented
Add or remove filter buttons	Windows`Ctrl` + `Shift` + `L` macOS`Cmd` + `Shift` + `F`
Hide selected rows	Windows / macOS`Ctrl` + `9`
Hide selected columns	Windows`Ctrl` + `0` macOS`Cmd` + `0`

Function keys and Copilot

Use function keys for help, navigation, selection, spelling, calculation, and the Copilot pane in current Excel desktop releases.

Action	Shortcuts
Open Excel HelpF1 is also the Windows binding.	WindowsNot documented macOS`F1`
Open Go ToF5 is also documented for Mac.	Windows`F5` macOSNot documented
Check spellingF7 is also documented for Mac.	Windows`F7` macOSNot documented
Turn Extend mode on or offF8 is also documented for Mac.	Windows`F8` macOSNot documented
Minimize the active window	WindowsNot documented macOS`Ctrl` + `F9`
Maximize or restore the active window	WindowsNot documented macOS`Ctrl` + `F10`
Open Copilot in Excel	Windows`Alt` + `C` macOS`Cmd` + `Ctrl` + `I`
Send a Copilot prompt	Windows`Enter` macOS`Return`
Cancel a Copilot request	Windows / macOS`Esc`
Accept Copilot changes	Windows`Ctrl` + `Enter` macOS`Cmd` + `Return`
Switch Copilot edit, chat, and plan mode	Windows`Ctrl` + `Shift` + `M` macOS`Cmd` + `Shift` + `M`
Navigate Copilot responses	Windows`Alt` + `C` macOS`Option` + `C`
Confirm selected Copilot files	Windows`Ctrl` + `J` macOS`Cmd` + `J`
Move focus between the grid and Copilot	Windows`F6` macOS`Shift` + `F6`

Source

official Microsoft Excel shortcut reference · Checked Aug 26, 2026

Microsoft's Excel shortcut reference checked in August 2026. It applies to Microsoft 365 and the listed recent Excel desktop releases; the source uses a US keyboard layout and warns that macOS settings, function-key preferences, and platform conflicts can change behavior.

Print the shortcuts you use

Make a printable Microsoft Excel sheet