Microsoft Excel keyboard shortcuts
Excel shortcuts are easiest to use when they follow the job in front of you: move through a grid, edit a cell, format a selection, work with data, and reach the ribbon or formula bar. This reference covers current desktop defaults for Windows and Mac.
Windows, macOS · 118 shortcutsCommon workbook actions
Save, open, close, print, edit, and reach the most-used Excel commands from either desktop platform.
| Action | Windows | macOS |
|---|---|---|
| Save the workbook | CtrlS | CmdS |
| Open a workbook | CtrlO | CmdO |
| Close the active workbook window | CtrlW | CmdW |
| Quit ExcelThe Excel reference lists Cmd+Q for Mac; close Excel on Windows with Alt+F4. | Not documented | CmdQ |
| Open Save As | F12 | CmdShiftS |
| Print the workbook | CtrlP | CmdP |
| Copy the selection | CtrlC | CmdC |
| Cut the selection | CtrlX | CmdX |
| Paste the selection | CtrlV | CmdV |
| Undo the last action | CtrlZ | CmdZ |
| Redo the last actionCmd+Shift+Z is also documented on Mac. | CtrlY | CmdY |
| Remove cell contents | Delete | Delete |
| Open Find | CtrlF | CmdF |
| Open Replace | CtrlH | CmdShiftH |
| Open Format Cells | Ctrl1 | Cmd1 |
| Select the current region or worksheetPress again to extend the selection; Cmd+Shift+Space is also documented on Mac. | CtrlA | CmdA |
| Open the context menuThe Mac reference also lists Shift+F10. | ShiftF10 | Not documented |
Ribbon and command access
Use Key Tips and focus movement to reach Excel commands without scanning the ribbon with a mouse.
| Action | Windows | macOS |
|---|---|---|
| Activate ribbon Key TipsF10 is an alternative on Windows. | Alt | Not documented |
| Move to the Search field | AltQ | Not documented |
| Open the File tab | AltF | Not documented |
| Open the Home tab | AltH | Not documented |
| Open the Insert tab | AltN | Not documented |
| Open the Page Layout tab | AltP | Not documented |
| Open the Formulas tab | AltM | Not documented |
| Open the Data tab | AltA | Not documented |
| Open the Review tab | AltR | Not documented |
| Open the View tab | AltW | Not documented |
| Move to the next ribbon command | Tab | Not documented |
| Move to the previous ribbon command | ShiftTab | Not documented |
| Show the focused ribbon tooltip | CtrlShiftF10 | Not documented |
| Expand or collapse the ribbon | CtrlF1 | CmdOptionR |
| Activate the focused ribbon commandEnter is also documented. | Space | Not documented |
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 | Windows | macOS |
|---|---|---|
| Select the entire row | ShiftSpace | ShiftSpace |
| Select the entire column | CtrlSpace | CtrlSpace |
| Extend the selection by one cell | ShiftArrow | ShiftArrow |
| Extend the selection to the data edge | CtrlShiftArrow | CtrlShiftArrow |
| Turn Extend mode on or offThe Mac reference also lists F8. | F8 | Not documented |
| Add a non-adjacent range to the selectionThe Mac reference also lists Shift+F8. | ShiftF8 | Not documented |
| Insert a line break in the same cell | AltEnter | CmdOptionReturn |
| Fill the selected range with the current entry | CtrlEnter | CmdReturn |
| Complete entry and select the cell above | ShiftEnter | ShiftReturn |
| Edit the active cell | F2 | F2 |
| Cancel a cell or formula-bar entry | Esc | Esc |
| Complete a cell entry | Enter | Return |
| Select the current data regionCmd+Shift+* is also documented on Mac. | CtrlShift* | Not documented |
| Select the entire worksheet | CtrlShiftSpace | CmdShiftSpace |
Formatting and cell commands
Format text and numbers, set borders, create tables, and reach the dialogs that change how a selection behaves.
| Action | Windows | macOS |
|---|---|---|
| Toggle bold | CtrlB | CmdB |
| Toggle italic | CtrlI | CmdI |
| Toggle underline | CtrlU | CmdU |
| Toggle strikethroughCmd+5 is also listed for Mac. | Ctrl5 | Not documented |
| Apply the General number format | CtrlShift~ | Not documented |
| Apply the Currency format | CtrlShift$ | Not documented |
| Apply the Percentage format | CtrlShift% | Not documented |
| Apply the Date format | CtrlShift# | Not documented |
| Apply the Time format | CtrlShift@ | Not documented |
| Apply an outline borderCmd+Option+0 is the Mac binding. | CtrlShift& | Not documented |
| Remove the outline borderCmd+Option+- is the Mac binding. | CtrlShift_ | Not documented |
| Show values or formulas | Ctrl` | Ctrl` |
| Fill down | CtrlD | CmdD |
| Fill right | CtrlR | CmdR |
| Open the Insert Cells dialogThe Mac reference uses Ctrl+Shift+=. | CtrlShift+ | Not documented |
| Open the Delete Cells dialog | Ctrl- | Cmd- |
| Open Insert Hyperlink | CtrlK | CmdK |
| Open Create Table | CtrlT | CmdT |
| Show Quick Analysis optionsThe Mac source does not list a separate equivalent in this section. | CtrlQ | Not 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 | Windows | macOS |
|---|---|---|
| Enter the current date | Ctrl; | Ctrl; |
| Enter the current time | CtrlShift; | Cmd; |
| Insert an AutoSum formula | Alt= | ShiftCmdT |
| Open Insert Function or Formula Builder | ShiftF3 | ShiftF3 |
| Expand or collapse the formula bar | CtrlShiftU | CtrlShiftU |
| Show formula tooltips | CtrlAltP | CtrlOptionP |
| Invoke Flash Fill | CtrlE | Not documented |
| Cycle absolute and relative references | F4 | F4 |
| Calculate all open workbooks | F9 | Cmd= |
| Calculate the active worksheet | ShiftF9 | ShiftF9 |
| Force a full calculation | CtrlAltF9 | Not documented |
| Create an embedded chartF11 creates a chart sheet. | AltF1 | Not documented |
| Open the Macro dialog | AltF8 | OptionF8 |
| Open the Visual Basic editor | AltF11 | OptionF11 |
| Open Power Query Editor | AltF12 | OptionF12 |
| Refresh data in the current worksheet | CtrlF5 | Not documented |
| Refresh all workbook data | CtrlAltF5 | Not documented |
| Add or remove filter buttons | CtrlShiftL | CmdShiftF |
| Hide selected rows | Ctrl9 | Ctrl9 |
| Hide selected columns | Ctrl0 | Cmd0 |
Function keys and Copilot
Use function keys for help, navigation, selection, spelling, calculation, and the Copilot pane in current Excel desktop releases.
| Action | Windows | macOS |
|---|---|---|
| Open Excel HelpF1 is also the Windows binding. | Not documented | F1 |
| Open Go ToF5 is also documented for Mac. | F5 | Not documented |
| Check spellingF7 is also documented for Mac. | F7 | Not documented |
| Turn Extend mode on or offF8 is also documented for Mac. | F8 | Not documented |
| Minimize the active window | Not documented | CtrlF9 |
| Maximize or restore the active window | Not documented | CtrlF10 |
| Open Copilot in Excel | AltC | CmdCtrlI |
| Send a Copilot prompt | Enter | Return |
| Cancel a Copilot request | Esc | Esc |
| Accept Copilot changes | CtrlEnter | CmdReturn |
| Switch Copilot edit, chat, and plan mode | CtrlShiftM | CmdShiftM |
| Navigate Copilot responses | AltC | OptionC |
| Confirm selected Copilot files | CtrlJ | CmdJ |
| Move focus between the grid and Copilot | F6 | ShiftF6 |