# Microsoft Excel keyboard shortcuts

[Original EspDesktop guide](https://espdesktop.com/reference/shortcut-presets/microsoft-excel)

![EspDesktop touchscreen on a desk stand beside a Mac keyboard](https://espdesktop.com/images/espdesktop-desk.jpg)

EspDesktop puts Microsoft Excel keyboard shortcuts on labelled buttons on a touchscreen beside your Mac. Keep those commands within reach while starting workbooks and organising spreadsheet data.

## What can I do with it?

Try Find in an open workbook. For New Table, select the range you want to turn into a table before tapping the shortcut.

Back to layout

New Workbook

Find

New Table

Add or remove filter

Insert AutoSum formula

Fill cells down

Use Paste Special

Insert new sheet

Example touchscreen buttons for Microsoft Excel

## Microsoft Excel shortcut reference

| Action | Keys |
| --- | --- |
| New Workbook | Command + N |
| From Template | Command + Shift + P |
| Find | Control + F |
| Search | Command + F |
| Line Break | Option + Enter |
| New Table | Command + T |
| Paste selection | Command + V |
| Paste selection | Control + V |
| Copy selection | Command + C |
| Copy selection | Control + C |
| Clear selection | Delete |
| Save workbook | Command + S |
| Save workbook | Control + S |
| Undo action | Command + Z |
| Undo action | Control + Z |
| Redo action | Command + Y |
| Redo action | Control + Y |
| Redo action | Command + Shift + Z |
| Cut selection | Command + X |
| Cut selection | Control + X |
| Cut selection | Shift + Delete |
| Apply bold formatting | Command + B |
| Apply bold formatting | Control + B |
| Print workbook | Command + P |
| Print workbook | Control + P |
| Open Visual Basic | Option + F11 |
| Fill cells down | Command + D |
| Fill cells down | Control + D |
| Fill cells right | Command + R |
| Fill cells right | Control + R |
| Insert cells | Control + Shift + = |
| Delete cells | Command + - |
| Delete cells | Control + - |
| Calculate all open workbooks | Command + = |
| Calculate all open workbooks | F9 |
| Close window | Command + W |
| Close window | Control + W |
| Quit Excel | Command + Q |
| Display Go To dialog box | Control + G |
| Display Go To dialog box | F5 |
| Display Format Cells dialog box | Command + 1 |
| Display Format Cells dialog box | Control + 1 |
| Display Replace dialog box | Control + H |
| Display Replace dialog box | Command + Shift + H |
| Use Paste Special | Command + Control + V |
| Use Paste Special | Control + Option + V |
| Use Paste Special | Command + Option + V |
| Apply underline formatting | Command + U |
| Apply italic formatting | Command + I |
| Apply italic formatting | Control + I |
| Open new blank workbook | Control + N |
| Display Save As dialog box | Command + Shift + S |
| Display Save As dialog box | F12 |
| Display Help window | F1 |
| Display Help window | Command + / |
| Select all | Command + A |
| Select all | Command + Shift + Space |
| Add or remove filter | Command + Shift + F |
| Add or remove filter | Control + Shift + L |
| Display Open dialog box | Command + O |
| Display Open dialog box | Control + O |
| Check spelling | F7 |
| Open thesaurus | Shift + F7 |
| Display Formula Builder | Shift + F3 |
| Open Define Name dialog box | Command + F3 |
| Insert or reply to threaded comment | Command + Enter |
| Open Create names dialog box | Command + Shift + F3 |
| Insert new sheet | Shift + F11 |
| Print preview | Command + P |
| Print preview | Control + P |
| Full screen view | Command + Control + F |
| Close active workbook window | Command + W |
| Take screenshot and save it on your desktop | Command + Shift + 3 |
| Maximize or restore window | Control + F10 |
| Maximize or restore window | Command + F10 |
| Hide Excel | Command + H |
| Next box, option, control, or command | Tab |
| Previous box, option, control, or command | Shift + Tab |
| Exit dialog box or cancel action | Escape |
| Perform action assigned to default button | Enter |
| Cancel command and close dialog box or menu | Escape |
| Move one cell up, down, left, or right | Left |
| Move one cell up, down, left, or right | Right |
| Move one cell up, down, left, or right | Up |
| Move one cell up, down, left, or right | Down |
| Edge of current data region Left | Command + Left |
| Edge of current data region Right | Command + Right |
| Edge of current data region Up | Command + Up |
| Edge of current data region Down | Command + Down |
| Beginning of row | Home |
| Beginning of sheet | Control + Home |
| Beginning of sheet | Control + Fn + Left |
| Last cell in use on sheet | Control + End |
| Last cell in use on sheet | Control + Fn + Right |
| Move down one screen | Pagedown |
| Move up one screen | Pageup |
| Move one screen to right | Option + Pagedown |
| Move one screen to left | Option + Pageup |
| Next sheet in workbook | Control + Pagedown |
| Next sheet in workbook | Option + Right |
| Previous sheet in workbook | Control + Pagedown |
| Previous sheet in workbook | Option + Left |
| Scroll to display cell | Control + Delete |
| Display Find dialog box | Shift + F5 |
| Move between unlocked cells | Tab |
| Edit cell | F2 |
| Complete cell entry and move forward | Enter |
| Start new line in same cell | Control + Option + Enter |
| Fill cell range with text that you type | Command + Enter |
| Fill cell range with text that you type | Control + Enter |
| Complete cell entry and move up in selection | Shift + Enter |
| Complete cell entry and move to right | Tab |
| Complete cell entry and move to left | Shift + Tab |
| Cancel cell entry | Escape |
| Delete character to left | Delete |
| Delete character to right | Delete |
| Delete text to end of line | Control + Delete |
| Delete text to end of line | Control + Fn + Delete |
| Move one character up, down, left, or right | Left |
| Move one character up, down, left, or right | Right |
| Move one character up, down, left, or right | Up |
| Move one character up, down, left, or right | Down |
| Beginning of line | Home |
| Insert note | Shift + F2 |
| Open and edit cell note | Shift + F2 |
| Insert threaded comment | Command + Shift + F2 |
| Open and reply to threaded comment | Command + Shift + F2 |
| Fill down | Control + D |
| Fill down | Command + D |
| Fill to right | Control + R |
| Fill to right | Command + R |
| Define name | Control + L |
| Toggle tooltips | Control + Option + P |
| Expand or collapse formula bar | Control + Shift + U |
| Edit cell and then clear it or delete preceding | Delete |
| Complete cell entry | Enter |
| Enter formula as array formula | Command + Shift + Enter |
| Enter formula as array formula | Control + Shift + Enter |
| Cancel entry in cell or formula bar | Escape |
| Display Formula Builder after you type valid | Control + A |
| Insert hyperlink | Command + K |
| Insert hyperlink | Control + K |
| Edit cell and position insertion point at end | Control + U |
| Open Formula Builder | Shift + F3 |
| Calculate active sheet | Shift + F9 |
| Display context menu | Shift + F10 |
| Start formula | \= |
| Toggle formula reference style between | Command + T |
| Toggle formula reference style between | F4 |
| Insert AutoSum formula | Command + Shift + T |
| Enter date | Control + ; |
| Enter time | Command + ; |
| Copy value | Control + Shift + ' |
| Alternate between displaying cell values | Control + \` |
| Copy formula | Control + ' |
| Display AutoComplete list | Option + Down |
| Open Smart Lookup pane | Command + Control + Option + L |
| Calculate all worksheets | Control + Option + F9 |
| Check dependent formulas, and then calculate | Control + Option + Shift + F9 |
| Create table | Command + T |
| Create table | Control + T |
| Insert line break in cell | Command + Option + Enter |
| Insert line break in cell | Control + Option + Enter |
| Increase font size | Command + Shift + . |
| Decrease font size | Command + Shift + , |
| Align center | Command + E |
| Align left | Command + L |
| Display Modify Cell Style dialog box | Command + Shift + L |
| Apply general number format | Control + Shift + \` |
| Apply currency format | Control + Shift + 4 |
| Apply percentage format | Control + Shift + 5 |
| Apply exponential number format | Control + Shift + 6 |
| Apply date format | Control + Shift + 1 |
| Apply date format | Control + Shift + 2 |
| Apply date format | Control + Shift + 3 |
| Apply date format | Control + Shift + 4 |
| Apply date format | Control + Shift + 5 |
| Apply date format | Control + Shift + 6 |
| Apply date format | Control + Shift + 7 |
| Apply date format | Control + Shift + 8 |
| Apply date format | Control + Shift + 9 |
| Apply time format | Control + Shift + 2 |
| Apply number format | Control + Shift + 1 |
| Apply outline border around selected cells | Command + Option + 0 |
| Add outline border to right of selection | Command + Option + Right |
| Add outline border to left of selection | Command + Option + Left |
| Add outline border to top of selection | Command + Option + Up |
| Add outline border to bottom of selection | Command + Option + Down |
| Remove outline borders | Command + Option + - |
| Apply or remove bold formatting | Command + B |
| Apply or remove italic formatting | Command + I |
| Apply or remove underline formatting | Command + U |
| Apply or remove strikethrough formatting | Command + Shift + X |
| Hide column | Command + Shift + 0 |
| Hide column | Control + Shift + 0 |
| Unhide column | Command + Shift + 0 |
| Unhide column | Control + Shift + 0 |
| Hide row | Command + Shift + 9 |
| Hide row | Control + Shift + 9 |
| Unhide row | Command + Shift + 9 |
| Unhide row | Control + Shift + 9 |
| Edit cell | Control + U |
| Paste text into cell | Command + V |
| Give selected cells cell's entry | Command + Enter |
| Give selected cells cell's entry | Control + Enter |
| Extend selection by one cell Left | Shift + Left |
| Extend selection by one cell Right | Shift + Right |
| Extend selection by one cell Up | Shift + Up |
| Extend selection by one cell Down | Shift + Down |
| Extend selection to last nonblank cell | Command + Shift + Left |
| Extend selection to last nonblank cell | Command + Shift + Right |
| Extend selection to last nonblank cell | Command + Shift + Up |
| Extend selection to last nonblank cell | Command + Shift + Down |
| Extend selection to beginning of row | Shift + Home |
| Extend selection to beginning of row | Shift + Fn + Left |
| Extend selection to beginning of sheet | Control + Shift + Home |
| Extend selection to beginning of sheet | Control + Shift + Fn + Left |
| Extend selection to last cell used | Control + Shift + End |
| Extend selection to last cell used | Control + Shift + Fn + Right |
| Select entire column | Control + Space |
| Select entire row | Shift + Space |
| Select current region or entire sheet | Command + A |
| Select only visible cells | Command + Shift + 8 |
| Select only cell when multiple cells are | Shift + Delete |
| Extend selection down one screen | Shift + Pagedown |
| Extend selection down one screen | Shift + Fn + Down |
| Extend selection up one screen | Shift + Pageup |
| Extend selection up one screen | Shift + Fn + Up |
| Alternate between hiding objects, displaying | Control + 6 |
| Turn | F8 |
| Add another range of cells to selection | Shift + F8 |
| Select current array | Control + / |
| Select cells | Control + \\ |
| Select only cells that are directly referred | Control + Shift + \[ |
| Select all cells that are directly | Control + Shift + \[ |
| Select only cells | Control + \] |
| Select all cells | Control + Shift + \] |
| Copy selection | Control + V |
| Delete selection | Control + - |
| Undo last action | Command + Z |
| Move | Enter |
| Move | Shift + Enter |
| Move | Tab |
| Move | Shift + Tab |
| Move clockwise to next corner of selection | Control + . |
| Group selected cells | Command + Shift + K |
| Ungroup selected cells | Command + Shift + J |
| Open Sort dialog box | Command + Shift + R |
| Display Filter list or PivotTable page or field | Option + Down |
| Send your prompt | Enter |
| Stop or cancel Copilot in Excel request | Escape |
| Accept changes made by Copilot in Excel | Command + Enter |
| Switch between edit, chat, and plan mode | Command + Shift + M |
| Navigate between chat responses | Option + C |
| Confirm use | Command + J |
| Start dictation for Copilot in Excel | Option + Shift + H |
| Open Copilot in Excel task pane | Command + Control + I |
| Move focus between Excel grid and Copilot | Shift + F6 |
| Insert note or open and edit cell note | Shift + F2 |
| Insert threaded comment or open and reply | Command + Shift + F2 |
| Open Save dialog box | Option + F2 |
| Close window or dialog box | Command + F4 |
| Search Sheet dialog box | Control + F5 |
| Switch focus between worksheet, ribbon, task | F6 |
| Switch focus between worksheet, ribbon, task | Shift + F6 |
| Open thesaurus | Command + Control + Option + R |
| Extend selection | F8 |
| Add to selection | Shift + F8 |
| Display Macro dialog box | Option + F8 |
| Display context menu, or "right click" menu | Shift + F10 |
| Display pop-up menu | Option + Shift + F10 |
| Insert new chart sheet.\* | F11 |
| Insert new sheet.\* | Shift + F11 |
| Insert Excel 4.0 macro sheet | Command + F11 |
| Display Open dialog box | Command + F12 |
| Open Power Query Editor | Option + F12 |
| Toggle Drawing mode on and off | Command + Control + Z |
| Apply outline border | Command + Option + 0 |
| Remove outline border | Command + Option + - |
| Hide column(s) | Command + 0 |
| Hide row(s) | Control + 9 |
| Unhide column(s) | Command + Shift + 0 |
| Unhide column(s) | Control + Shift + 0 |
| Unhide row(s) | Control + Shift + 9 |
| Cell on right | Tab |
| Move within cell text Left | Left |
| Move within cell text Right | Right |
| Move within cell text Up | Up |
| Move within cell text Down | Down |
| Apply bold formatting to text | Command + B |
| Apply italic formatting to text | Command + I |
| Underline text | Command + U |
| Select range of cells Left | Shift + Left |
| Select range of cells Right | Shift + Right |
| Insert line break within cell | Command + Option + Enter |
| Insert line break within cell | Control + Option + Enter |
| Move cursor to beginning | Command + Left |
| Move cursor to end of line within cell | Command + Right |
| Move cursor to beginning of cell | Command + Up |
| Move cursor to end of cell | Command + Down |
| Move cursor up | Option + Up |
| Move cursor down | Option + Down |
| Move cursor right by one word | Option + Right |
| Move cursor left by one word | Option + Left |
| Accept changes made by Copilot in Excel | Control + Enter |
| Switch between edit, chat, and plan mode | Control + Shift + M |
| Confirm use | Control + J |
| Open Copilot in Excel task pane | Option + C |
| Move focus between Excel grid and Copilot | F6 |

## Microsoft Excel shortcuts FAQ

### Which Microsoft Excel keyboard shortcuts should I try first?

Start with **New Workbook** (**Command + N**), **Find** (**Control + F**) and **New Table** (**Command + T**). Tapping a button sends its key combination to Microsoft Excel on your Mac.

### How do I add Microsoft Excel shortcuts to EspDesktop?

Add an **Applications** card for Microsoft Excel and choose the shortcuts you want under **App Subpage**. For one button, use a **Key Shortcut** card and pick Microsoft Excel in the **Application** tab. See [how to add shortcut cards](https://espdesktop.com/mac-controls/shortcuts#create-a-shortcut-card).

### Can I choose which Microsoft Excel shortcuts appear on the display?

Yes. You can choose and reorder cards in the app subpage. You can also [add a custom keyboard shortcut](https://espdesktop.com/mac-controls/shortcuts#create-a-shortcut-card) for a key combination you use in Microsoft Excel.

### Why is a Microsoft Excel shortcut not responding?

Try the keys shown in the table on your Mac first, with Microsoft Excel open and the right window or item selected. If the keys work on your Mac, check [EspDesktop’s Accessibility permission](https://espdesktop.com/mac-controls/shortcuts#allow-accessibility-access).

[Browse all application shortcuts](https://espdesktop.com/reference/shortcut-presets).

[Next · Setup guide](https://espdesktop.com/screens/4848s040#where-to-buy)
