Microsoft Excel Keyboard Shortcuts for macOS

Microsoft Excel Keyboard Shortcuts for MacOS. View hotkeys online or download free PDF Cheat Sheet to work faster and master spreadsheets on Mac.

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