Microsoft Excel Keyboard Shortcuts for macOS

Keyboard shortcuts for Microsoft Excel on Mac. Navigate cells, build formulas, and apply number formatting on macOS.

Paste selection: Cmd+V
or
Ctrl+V
Copy selection: Cmd+C
or
Ctrl+C
Clear selection: Del
Save workbook: Cmd+S
or
Ctrl+S
Undo action: Cmd+Z
or
Ctrl+Z
Redo action: Cmd+Y
or
Ctrl+Y
or
Cmd+Shift+Z
Cut selection: Cmd+X
or
Ctrl+X
or
Shift+Fwd Del
Apply bold formatting: Cmd+B
or
Ctrl+B
Print workbook: Cmd+P
or
Ctrl+P
Open Visual Basic: Opt+F11
Fill cells down: Cmd+D
or
Ctrl+D
Fill cells right: Cmd+R
or
Ctrl+R
Insert cells: Ctrl+Shift+=
Delete cells: Cmd+-
or
Ctrl+-
Calculate all open workbooks: F9
or
Cmd+=
Close window: Cmd+W
or
Ctrl+W
Quit Excel: Cmd+Q
Display the Go To dialog box: Ctrl+G
or
F5
Display the Format Cells dialog box: Cmd+1
or
Ctrl+1
Display the Replace dialog box: Ctrl+H
or
Cmd+Shift+H

Use Paste Special: Cmd+Ctrl+V
or
Ctrl+Opt+V
or
Cmd+Opt+V
Apply underline formatting: Cmd+U
Apply italic formatting: Cmd+I
or
Ctrl+I
Open a new blank workbook: Cmd+N
or
Ctrl+N
Create a new workbook from template: Cmd+Shift+P
Display the Save As dialog box: Cmd+Shift+S
or
F12
Display the Help window: F1
or
Cmd+/
Select all: Cmd+A
or
Cmd+Shift+Space
Add or remove a filter: Cmd+Shift+F
or
Ctrl+Shift+L
Minimize or maximize the ribbon tabs: Cmd+Opt+R
Display the Open dialog box: Cmd+O
or
Ctrl+O
Check spelling: F7
Open the thesaurus: Shift+F7
Display the Formula Builder: Shift+F3
Open the Define Name dialog box: Cmd+F3
Insert or reply to a threaded comment: Cmd+Return
Open the Create names dialog box: Cmd+Shift+F3
Insert a new sheet: Shift+F11
Print preview: Cmd+P
or
Ctrl+P

Expand or minimize the ribbon: Cmd+Opt+R
Switch to full screen view: Cmd+Ctrl+F
Switch to the next application: Cmd+Tab
Switch to the previous application: Cmd+Shift+Tab
Close the active workbook window: Cmd+W
Take a screenshot and save it on your desktop: Cmd+Shift+3
Minimize the active window: Ctrl+F9

Maximize or restore the active window: Ctrl+F10
or
Cmd+F10
Hide Excel: Cmd+H
Move to the next box, option, control, or command: Tab
Move to the previous box, option, control, or command: Shift+Tab
Exit a dialog box or cancel an action: Esc
Perform the action assigned to the default button (the button with the bold outline): Return
Cancel the command and close the dialog box or menu: Esc

Move one cell up, down, left, or right: UpDownLeftRight
Move to the edge of the current data region: Cmd+UpDownLeftRight
Move to the beginning of the row: Home
or
Fn+Left
Move to the beginning of the sheet: Ctrl+Home
or
Ctrl+Fn+Left
Move to the last cell in use on the sheet: Ctrl+End
or
Ctrl+Fn+Right
Move down one screen: Pg Dn
or
Fn+Down
Move up one screen: Pg Up
or
Fn+Up
Move one screen to the right: Opt+Pg Dn
or
Opt+Fn+Down
Move one screen to the left: Opt+Pg Up
or
Opt+Fn+Up

Move to the next sheet in the workbook: Ctrl+Pg Dn
or
Opt+Right
Move to the previous sheet in the workbook: Ctrl+Pg Dn
or
Opt+Left
Scroll to display the active cell: Ctrl+Del
Display the Go To dialog box: Ctrl+G
Display the Find dialog box: Ctrl+F
or
Shift+F5
Access search (when in a cell or when a cell is selected): Cmd+F
Move between unlocked cells on a protected sheet: Tab
Scroll horizontally: Shift+Scroll Up
or
Shift+Scroll Down

Edit the selected cell: F2
Complete a cell entry and move forward in the selection: Return
Start a new line in the same cell: Opt+Return
or
Ctrl+Opt+Return
Fill the selected cell range with the text that you type: Cmd+Return
or
Ctrl+Return
Complete a cell entry and move up in the selection: Shift+Return
Complete a cell entry and move to the right in the selection: Tab
Complete a cell entry and move to the left in the selection: Shift+Tab
Cancel a cell entry: Esc
Delete the character to the left of the insertion point or delete the selection: Del
Delete the character to the right of the insertion point or delete the selection. Note: Some smaller keyboards do not have this key: Fwd Del
or
Fn+Del

Delete text to the end of the line. Note: Some smaller keyboards do not have this key: Ctrl+Fwd Del
or
Ctrl+Fn+Del
Move one character up, down, left, or right: UpDownLeftRight
Move to the beginning of the line: Home
or
Fn+Left
Insert a note: Shift+F2
Open and edit a cell note: Shift+F2
Insert a threaded comment: Cmd+Shift+F2
Open and reply to a threaded comment: Cmd+Shift+F2
Fill down: Ctrl+D
or
Cmd+D
Fill to the right: Ctrl+R
or
Cmd+R
Define a name: Ctrl+L

Turn on or off tooltips for checking formulas directly in the formula bar: Ctrl+Opt+P
Edit the selected cell: F2
Expand or collapse the formula bar: Ctrl+Shift+U
Edit the active cell and then clear it or delete the preceding character in the active cell as you edit the cell contents: Del
Complete a cell entry: Return
Enter a formula as an array formula: Cmd+Shift+Return
or
Ctrl+Shift+Return
Cancel an entry in the cell or formula bar: Esc
Display the Formula Builder after you type a valid function name in a formula: Ctrl+A
Insert a hyperlink: Cmd+K
or
Ctrl+K
Edit the active cell and position the insertion point at the end of the line: Ctrl+U
Open the Formula Builder: Shift+F3
Calculate the active sheet: Shift+F9
Display the context menu: Shift+F10

Start a formula: =
Toggle the formula reference style between absolute, relative, and mixed: Cmd+T
or
F4
Insert the AutoSum formula: Cmd+Shift+T
Enter the date: Ctrl+;
Enter the time: Cmd+;
Copy the value from the cell above the active cell into the cell or the formula bar: Ctrl+Shift+'
Alternate between displaying cell values and displaying cell formulas: Ctrl+`
Copy a formula from the cell above the active cell into the cell or the formula bar: Ctrl+'
Display the AutoComplete list: Opt+Down
Define a name: Ctrl+L
Open the Smart Lookup pane: Cmd+Ctrl+Opt+L
Calculate all worksheets in all open workbooks: Ctrl+Opt+F9
Check dependent formulas, and then calculate all cells in all open workbooks: Ctrl+Opt+Shift+F9

Edit the selected cell: F2
Create a table: Cmd+T
or
Ctrl+T
Insert a line break in a cell: Cmd+Opt+Return
or
Ctrl+Opt+Return
Insert special characters like symbols, including emoji: Cmd+Ctrl+Space
Increase font size: Cmd+Shift+.
Decrease font size.: Cmd+Shift+,
Align center: Cmd+E
Align left: Cmd+L
Display the Modify Cell Style dialog box: Cmd+Shift+L
Display the Format Cells dialog box: Cmd+1
Apply the general number format: Ctrl+Shift+`
Apply the currency format with two decimal places (negative numbers appear in red with parentheses): Ctrl+Shift+4
Apply the percentage format with no decimal places: Ctrl+Shift+5
Apply the exponential number format with two decimal places: Ctrl+Shift+6
Apply the date format with the day, month, and year: Ctrl+Shift+3
Apply the time format with the hour and minute, and indicate AM or PM: Ctrl+Shift+2
Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values: Ctrl+Shift+1
Apply the outline border around the selected cells: Cmd+Opt+0
Add an outline border to the right of the selection: Cmd+Opt+Right
Add an outline border to the left of the selection: Cmd+Opt+Left

Add an outline border to the top of the selection: Cmd+Opt+Up
Add an outline border to the bottom of the selection: Cmd+Opt+Down
Remove outline borders: Cmd+Opt+-
Apply or remove bold formatting: Cmd+B
Apply or remove italic formatting: Cmd+I
Apply or remove underline formatting: Cmd+U
Apply or remove strikethrough formatting: Cmd+Shift+X
Hide a column: Cmd+Shift+0
or
Ctrl+Shift+0
Unhide a column: Cmd+Shift+0
or
Ctrl+Shift+0
Hide a row: Cmd+Shift+9
or
Ctrl+Shift+9
Unhide a row: Cmd+Shift+9
or
Ctrl+Shift+9
Edit the active cell: Ctrl+U
Cancel an entry in the cell or the formula bar: Esc
Edit the active cell and then clear it or delete the preceding character in the active cell as you edit the cell contents: Del
Paste text into the active cell: Cmd+V
Complete a cell entry: Return
Give selected cells the current cell's entry: Cmd+Return
or
Ctrl+Return
Enter a formula as an array formula: Cmd+Shift+Return
or
Ctrl+Shift+Return
Display the Formula Builder after you type a valid function name in a formula: Ctrl+A

Extend the selection by one cell: Shift+UpDownLeftRight
Extend the selection to the last nonblank cell in the same column or row as the active cell: Cmd+Shift+UpDownLeftRight
Extend the selection to the beginning of the row: Shift+Home
or
Shift+Fn+Left
Extend the selection to the beginning of the sheet: Ctrl+Shift+Home
or
Ctrl+Shift+Fn+Left
Extend the selection to the last cell used on the sheet (lower-right corner): Ctrl+Shift+End
or
Ctrl+Shift+Fn+Right
Select the entire column: Ctrl+Space
Select the entire row: Shift+Space
Select the current region or entire sheet. Press more than once to expand the selection: Cmd+A
Select only visible cells: Cmd+Shift+8
Select only the active cell when multiple cells are selected: Shift+Del
Extend the selection down one screen: Shift+Pg Dn
or
Shift+Fn+Down

Extend the selection up one screen: Shift+Pg Up
or
Shift+Fn+Up
Alternate between hiding objects, displaying objects, and displaying placeholders for objects: Ctrl+6
Turn on the capability to extend a selection by using the arrow keys: F8
Add another range of cells to the selection: Shift+F8
Select the current array, which is the array that the active cell belongs to: Ctrl+/
Select cells in a row that don't match the value in the active cell in that row: Ctrl+\
Select only cells that are directly referred to by formulas in the selection: Ctrl+[
Select all cells that are directly or indirectly referred to by formulas in the selection: Ctrl+Shift+[
Select only cells with formulas that refer directly to the active cell: Ctrl+]
Select all cells with formulas that refer directly or indirectly to the active cell: Ctrl+Shift+]

Copy a selection: Cmd+C
or
Ctrl+C
Paste a selection: Cmd+V
or
Ctrl+V
Cut a selection: Cmd+X
or
Ctrl+X
Clear a selection: Del
Delete the selection: Ctrl+-
Undo the last action: Cmd+Z
Hide a column: Cmd+Shift+0
or
Ctrl+Shift+0
Unhide a column: Cmd+Shift+0
or
Ctrl+Shift+0
Hide a row: Cmd+Shift+9
or
Ctrl+Shift+9

Unhide a row: Cmd+Shift+9
or
Ctrl+Shift+9
Move selected rows, columns, or cells: Shift+MouseDrag
Move from top to bottom within the selection (down): Return
Move from bottom to top within the selection (up): Shift+Return
Move from left to right within the selection, or move down one cell if only one column is selected: Tab
Move from right to left within the selection, or move up one cell if only one column is selected: Shift+Tab
Move clockwise to the next corner of the selection: Ctrl+.
Group selected cells: Cmd+Shift+K
Ungroup selected cells: Cmd+Shift+J

Insert a new chart sheet: F11

Cycle through chart object selection: UpDownLeftRight

Open the Sort dialog box: Cmd+Shift+R
Add or remove a filter: Cmd+Shift+F
or
Ctrl+Shift+L

Display the Filter list or PivotTable page field pop-up menu for the selected cell: Opt+Down

Display or hide outline symbols: Ctrl+8
Hide selected rows: Ctrl+9
Unhide selected rows: Ctrl+Shift+9

Hide selected columns: Ctrl+0
Unhide selected columns: Ctrl+Shift+0

Display the Help window: F1
Edit the selected cell: F2
Insert a note or open and edit a cell note: Shift+F2
Insert a threaded comment or open and reply to a threaded comment: Cmd+Shift+F2
Open the Save dialog box: Opt+F2
Open the Formula Builder: Shift+F3
Open the Define Name dialog box: Cmd+F3
Close a window or a dialog box: Cmd+F4
Display the Go To dialog box: F5
Display the Find dialog box: Shift+F5
Move to the Search Sheet dialog box: Ctrl+F5
Switch focus between the worksheet, ribbon, task pane, and status bar: F6
or
Shift+F6
Check spelling: F7
Open the thesaurus: Shift+F7
or
Cmd+Ctrl+Opt+R
Extend the selection: F8

Add to the selection: Shift+F8
Display the Macro dialog box: Opt+F8
Calculate all open workbooks: F9
Calculate the active sheet: Shift+F9
Minimize the active window: Ctrl+F9
Display the context menu, or "right click" menu: Shift+F10
Display a pop-up menu (on object button menu), such as by clicking the button after you paste into a sheet: Opt+Shift+F10
Maximize or restore the active window: Ctrl+F10
or
Cmd+F10
Insert a new chart sheet.*: F11
Insert a new sheet.*: Shift+F11
Insert an Excel 4.0 macro sheet: Cmd+F11
Open Visual Basic: Opt+F11
Display the Save As dialog box: F12
Display the Open dialog box: Cmd+F12
Open the Power Query Editor: Opt+F12

Toggle Drawing mode on and off: Cmd+Ctrl+Z

Need more than shortcuts?
Visit the Microsoft Excel app page for an overview and helpful links.

Want to suggest a new app, report a bug, or get help? Email us at info@hkeys.app.

For anything else or just a quick hello, write to us at info@hkeys.app.

Microsoft Excel Keyboard Shortcuts for macOS

Frequently used shortcuts

Work in windows and dialog boxes

Move and scroll in a sheet or workbook

Enter data on a sheet

Work in cells or the Formula bar

Format and edit data

Select cells, columns, or rows

Work with a selection

Use charts

Sort, filter, and use PivotTable reports

Outline data

Use function key shortcuts

Drawing