Skip to content

Microsoft Excel keyboard shortcuts ​

EspDesktop touchscreen on a desk stand beside a Mac keyboard

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 ​

ActionKeys
New WorkbookCommand + N
From TemplateCommand + Shift + P
FindControl + F
SearchCommand + F
Line BreakOption + Enter
New TableCommand + T
Paste selectionCommand + V
Paste selectionControl + V
Copy selectionCommand + C
Copy selectionControl + C
Clear selectionDelete
Save workbookCommand + S
Save workbookControl + S
Undo actionCommand + Z
Undo actionControl + Z
Redo actionCommand + Y
Redo actionControl + Y
Redo actionCommand + Shift + Z
Cut selectionCommand + X
Cut selectionControl + X
Cut selectionShift + Delete
Apply bold formattingCommand + B
Apply bold formattingControl + B
Print workbookCommand + P
Print workbookControl + P
Open Visual BasicOption + F11
Fill cells downCommand + D
Fill cells downControl + D
Fill cells rightCommand + R
Fill cells rightControl + R
Insert cellsControl + Shift + =
Delete cellsCommand + -
Delete cellsControl + -
Calculate all open workbooksCommand + =
Calculate all open workbooksF9
Close windowCommand + W
Close windowControl + W
Quit ExcelCommand + Q
Display Go To dialog boxControl + G
Display Go To dialog boxF5
Display Format Cells dialog boxCommand + 1
Display Format Cells dialog boxControl + 1
Display Replace dialog boxControl + H
Display Replace dialog boxCommand + Shift + H
Use Paste SpecialCommand + Control + V
Use Paste SpecialControl + Option + V
Use Paste SpecialCommand + Option + V
Apply underline formattingCommand + U
Apply italic formattingCommand + I
Apply italic formattingControl + I
Open new blank workbookControl + N
Display Save As dialog boxCommand + Shift + S
Display Save As dialog boxF12
Display Help windowF1
Display Help windowCommand + /
Select allCommand + A
Select allCommand + Shift + Space
Add or remove filterCommand + Shift + F
Add or remove filterControl + Shift + L
Display Open dialog boxCommand + O
Display Open dialog boxControl + O
Check spellingF7
Open thesaurusShift + F7
Display Formula BuilderShift + F3
Open Define Name dialog boxCommand + F3
Insert or reply to threaded commentCommand + Enter
Open Create names dialog boxCommand + Shift + F3
Insert new sheetShift + F11
Print previewCommand + P
Print previewControl + P
Full screen viewCommand + Control + F
Close active workbook windowCommand + W
Take screenshot and save it on your desktopCommand + Shift + 3
Maximize or restore windowControl + F10
Maximize or restore windowCommand + F10
Hide ExcelCommand + H
Next box, option, control, or commandTab
Previous box, option, control, or commandShift + Tab
Exit dialog box or cancel actionEscape
Perform action assigned to default buttonEnter
Cancel command and close dialog box or menuEscape
Move one cell up, down, left, or rightLeft
Move one cell up, down, left, or rightRight
Move one cell up, down, left, or rightUp
Move one cell up, down, left, or rightDown
Edge of current data region LeftCommand + Left
Edge of current data region RightCommand + Right
Edge of current data region UpCommand + Up
Edge of current data region DownCommand + Down
Beginning of rowHome
Beginning of sheetControl + Home
Beginning of sheetControl + Fn + Left
Last cell in use on sheetControl + End
Last cell in use on sheetControl + Fn + Right
Move down one screenPagedown
Move up one screenPageup
Move one screen to rightOption + Pagedown
Move one screen to leftOption + Pageup
Next sheet in workbookControl + Pagedown
Next sheet in workbookOption + Right
Previous sheet in workbookControl + Pagedown
Previous sheet in workbookOption + Left
Scroll to display cellControl + Delete
Display Find dialog boxShift + F5
Move between unlocked cellsTab
Edit cellF2
Complete cell entry and move forwardEnter
Start new line in same cellControl + Option + Enter
Fill cell range with text that you typeCommand + Enter
Fill cell range with text that you typeControl + Enter
Complete cell entry and move up in selectionShift + Enter
Complete cell entry and move to rightTab
Complete cell entry and move to leftShift + Tab
Cancel cell entryEscape
Delete character to leftDelete
Delete character to rightDelete
Delete text to end of lineControl + Delete
Delete text to end of lineControl + Fn + Delete
Move one character up, down, left, or rightLeft
Move one character up, down, left, or rightRight
Move one character up, down, left, or rightUp
Move one character up, down, left, or rightDown
Beginning of lineHome
Insert noteShift + F2
Open and edit cell noteShift + F2
Insert threaded commentCommand + Shift + F2
Open and reply to threaded commentCommand + Shift + F2
Fill downControl + D
Fill downCommand + D
Fill to rightControl + R
Fill to rightCommand + R
Define nameControl + L
Toggle tooltipsControl + Option + P
Expand or collapse formula barControl + Shift + U
Edit cell and then clear it or delete precedingDelete
Complete cell entryEnter
Enter formula as array formulaCommand + Shift + Enter
Enter formula as array formulaControl + Shift + Enter
Cancel entry in cell or formula barEscape
Display Formula Builder after you type validControl + A
Insert hyperlinkCommand + K
Insert hyperlinkControl + K
Edit cell and position insertion point at endControl + U
Open Formula BuilderShift + F3
Calculate active sheetShift + F9
Display context menuShift + F10
Start formula=
Toggle formula reference style betweenCommand + T
Toggle formula reference style betweenF4
Insert AutoSum formulaCommand + Shift + T
Enter dateControl + ;
Enter timeCommand + ;
Copy valueControl + Shift + '
Alternate between displaying cell valuesControl + `
Copy formulaControl + '
Display AutoComplete listOption + Down
Open Smart Lookup paneCommand + Control + Option + L
Calculate all worksheetsControl + Option + F9
Check dependent formulas, and then calculateControl + Option + Shift + F9
Create tableCommand + T
Create tableControl + T
Insert line break in cellCommand + Option + Enter
Insert line break in cellControl + Option + Enter
Increase font sizeCommand + Shift + .
Decrease font sizeCommand + Shift + ,
Align centerCommand + E
Align leftCommand + L
Display Modify Cell Style dialog boxCommand + Shift + L
Apply general number formatControl + Shift + `
Apply currency formatControl + Shift + 4
Apply percentage formatControl + Shift + 5
Apply exponential number formatControl + Shift + 6
Apply date formatControl + Shift + 1
Apply date formatControl + Shift + 2
Apply date formatControl + Shift + 3
Apply date formatControl + Shift + 4
Apply date formatControl + Shift + 5
Apply date formatControl + Shift + 6
Apply date formatControl + Shift + 7
Apply date formatControl + Shift + 8
Apply date formatControl + Shift + 9
Apply time formatControl + Shift + 2
Apply number formatControl + Shift + 1
Apply outline border around selected cellsCommand + Option + 0
Add outline border to right of selectionCommand + Option + Right
Add outline border to left of selectionCommand + Option + Left
Add outline border to top of selectionCommand + Option + Up
Add outline border to bottom of selectionCommand + Option + Down
Remove outline bordersCommand + Option + -
Apply or remove bold formattingCommand + B
Apply or remove italic formattingCommand + I
Apply or remove underline formattingCommand + U
Apply or remove strikethrough formattingCommand + Shift + X
Hide columnCommand + Shift + 0
Hide columnControl + Shift + 0
Unhide columnCommand + Shift + 0
Unhide columnControl + Shift + 0
Hide rowCommand + Shift + 9
Hide rowControl + Shift + 9
Unhide rowCommand + Shift + 9
Unhide rowControl + Shift + 9
Edit cellControl + U
Paste text into cellCommand + V
Give selected cells cell's entryCommand + Enter
Give selected cells cell's entryControl + Enter
Extend selection by one cell LeftShift + Left
Extend selection by one cell RightShift + Right
Extend selection by one cell UpShift + Up
Extend selection by one cell DownShift + Down
Extend selection to last nonblank cellCommand + Shift + Left
Extend selection to last nonblank cellCommand + Shift + Right
Extend selection to last nonblank cellCommand + Shift + Up
Extend selection to last nonblank cellCommand + Shift + Down
Extend selection to beginning of rowShift + Home
Extend selection to beginning of rowShift + Fn + Left
Extend selection to beginning of sheetControl + Shift + Home
Extend selection to beginning of sheetControl + Shift + Fn + Left
Extend selection to last cell usedControl + Shift + End
Extend selection to last cell usedControl + Shift + Fn + Right
Select entire columnControl + Space
Select entire rowShift + Space
Select current region or entire sheetCommand + A
Select only visible cellsCommand + Shift + 8
Select only cell when multiple cells areShift + Delete
Extend selection down one screenShift + Pagedown
Extend selection down one screenShift + Fn + Down
Extend selection up one screenShift + Pageup
Extend selection up one screenShift + Fn + Up
Alternate between hiding objects, displayingControl + 6
TurnF8
Add another range of cells to selectionShift + F8
Select current arrayControl + /
Select cellsControl + \
Select only cells that are directly referredControl + Shift + [
Select all cells that are directlyControl + Shift + [
Select only cellsControl + ]
Select all cellsControl + Shift + ]
Copy selectionControl + V
Delete selectionControl + -
Undo last actionCommand + Z
MoveEnter
MoveShift + Enter
MoveTab
MoveShift + Tab
Move clockwise to next corner of selectionControl + .
Group selected cellsCommand + Shift + K
Ungroup selected cellsCommand + Shift + J
Open Sort dialog boxCommand + Shift + R
Display Filter list or PivotTable page or fieldOption + Down
Send your promptEnter
Stop or cancel Copilot in Excel requestEscape
Accept changes made by Copilot in ExcelCommand + Enter
Switch between edit, chat, and plan modeCommand + Shift + M
Navigate between chat responsesOption + C
Confirm useCommand + J
Start dictation for Copilot in ExcelOption + Shift + H
Open Copilot in Excel task paneCommand + Control + I
Move focus between Excel grid and CopilotShift + F6
Insert note or open and edit cell noteShift + F2
Insert threaded comment or open and replyCommand + Shift + F2
Open Save dialog boxOption + F2
Close window or dialog boxCommand + F4
Search Sheet dialog boxControl + F5
Switch focus between worksheet, ribbon, taskF6
Switch focus between worksheet, ribbon, taskShift + F6
Open thesaurusCommand + Control + Option + R
Extend selectionF8
Add to selectionShift + F8
Display Macro dialog boxOption + F8
Display context menu, or "right click" menuShift + F10
Display pop-up menuOption + Shift + F10
Insert new chart sheet.*F11
Insert new sheet.*Shift + F11
Insert Excel 4.0 macro sheetCommand + F11
Display Open dialog boxCommand + F12
Open Power Query EditorOption + F12
Toggle Drawing mode on and offCommand + Control + Z
Apply outline borderCommand + Option + 0
Remove outline borderCommand + 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 rightTab
Move within cell text LeftLeft
Move within cell text RightRight
Move within cell text UpUp
Move within cell text DownDown
Apply bold formatting to textCommand + B
Apply italic formatting to textCommand + I
Underline textCommand + U
Select range of cells LeftShift + Left
Select range of cells RightShift + Right
Insert line break within cellCommand + Option + Enter
Insert line break within cellControl + Option + Enter
Move cursor to beginningCommand + Left
Move cursor to end of line within cellCommand + Right
Move cursor to beginning of cellCommand + Up
Move cursor to end of cellCommand + Down
Move cursor upOption + Up
Move cursor downOption + Down
Move cursor right by one wordOption + Right
Move cursor left by one wordOption + Left
Accept changes made by Copilot in ExcelControl + Enter
Switch between edit, chat, and plan modeControl + Shift + M
Confirm useControl + J
Open Copilot in Excel task paneOption + C
Move focus between Excel grid and CopilotF6

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.

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 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.

Browse all application shortcuts.

Buy me a coffee