Topics Map > Mac
Topics Map > Office 365 > Excel
Microsoft Excel - Keyboard shortcuts for Mac Excel
This topic itemizes all keyboard shortcuts for Excel 2016 for Mac. Keyboard shortcuts allow you to quickly complete commands and functions without using a mouse. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel 2016 for Mac. However, not all do. The shortcuts in this article refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard.
- If a shortcut requires pressing two or more keys at the same time, this topic separates the keys with a plus sign (+). If you have to press one key immediately after another, the keys are separated by a comma (,).
- The settings in some versions of the Mac operating system (OS) and some utility applications might conflict with keyboard shortcuts and function key operations in Office 2016 for Mac. For information about changing the key assignment of a keyboard shortcut, see Mac Help for your version of the Mac OS or see your utility application. Also see Shortcut conflicts later in this topic.
This table itemizes the most frequently used shortcuts in Excel 2016 for Mac. To do this Press Paste Copy Clear DELETE Save Undo Redo Cut Bold Print Open Visual Basic OPTION + F11 Fill Down Fill Right Insert cells CONTROL + SHIFT + = Delete cells Calculate all open workbooks Close window Quit Excel Display the Go To dialog box CONTROL + G Display the Format Cells dialog box Display the Replace dialog box CONTROL + H Paste Special Underline Italic New blank workbook New workbook from template Display the Save As dialog box Display the Help window F1 Select All Add or remove a filter Minimize or maximize the ribbon tabs Display the Open dialog box Check spelling F7 Open the thesaurus SHIFT + F7 Display the Formula Builder SHIFT + F3 Open the Define Name dialog box Open the Create names dialog box Insert a new sheet * SHIFT + F11 Print Print preview Many keyboards assign special functions to function keys, by default. To use the function key for other purposes, you have to press Fn+the function key. Some Windows keyboard shortcuts conflict with the corresponding default Mac OS keyboard shortcuts. This topic flags such shortcuts with an asterisk ( * ). To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key. On the Apple menu, press System Preferences. Press Keyboard. In the tabs, press Shortcuts. Click Mission Control. Clear the check box for the keyboard shortcut that you want to use. To do this Press Expand or minimize the ribbon Switch to full screen view Switch to the next application Switch to the previous application Close the active workbook window Copy the image of the screen and save it to Minimize the active window CONTROL + F9 Maximize or restore the active window CONTROL + F10 Hide Excel. Move to the next box, option, control, or command TAB Move to the previous box, option, control, or command SHIFT + TAB Exit a dialog or cancel an action ESC Perform the action assigned to the default command button (the button with the bold outline, often the OK button) RETURN Cancel the command and close ESC To do this Press Move one cell up, down, left, or right ARROW KEYS Move to the edge of the current data region Move to the beginning of the row HOME Move to the beginning of the sheet CONTROL + HOME Move to the last cell in use on the sheet CONTROL + END Move down one screen PAGE DOWN Move up one screen PAGE UP Move one screen to the right OPTION + PAGE DOWN Move one screen to the left OPTION + PAGE UP Move to the next sheet in the workbook CONTROL + PAGE DOWN Move to the previous sheet in the workbook CONTROL + PAGE DOWN Scroll to display the active cell CONTROL + DELETE Display the Go To dialog box CONTROL + G Display the Find dialog box CONTROL + F Access search (when in a cell or when a cell is selected) Move between unlocked cells on a protected sheet TAB To do this Press Edit the selected cell F2 Complete a cell entry and move forward in the selection RETURN Start a new line in the same cell CONTROL + OPTION + RETURN Fill the selected cell range with the text that you type 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 DELETE Delete the character to the right of the insertion point, or delete the selection Delete text to the end of the line CONTROL + Move one character up, down, left, or right ARROW KEYS Move to the beginning of the line HOME Insert a comment SHIFT + F2 Open and edit a cell comment SHIFT + F2 Fill down CONTROL + D Fill to the right CONTROL + R Define a name CONTROL + L To do this Press Edit the selected cell F2 Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents DELETE Complete a cell entry RETURN Enter a formula as an array formula Cancel an entry in the cell or formula bar ESC Display the Formula Builder after you type a valid function name in a formula CONTROL + A Insert a hyperlink Edit the active cell and position the insertion point at the end of the line CONTROL + U Open the Formula Builder SHIFT + F3 Calculate the active sheet SHIFT + F9 Display a contextual menu SHIFT + F10 Start a formula = Toggle the formula reference style between absolute, relative, and mixed Insert the AutoSum formula Enter the date CONTROL + SEMICOLON (;) Enter the time Copy the value from the cell above the active cell into the cell or the formula bar CONTROL + SHIFT + INCH MARK (") Alternate between displaying cell values and displaying cell formulas CONTROL + GRAVE ACCENT (`) Copy a formula from the cell above the active cell into the cell or the formula bar CONTROL + APOSTROPHE (') Display the AutoComplete list CONTROL + OPTION + DOWN ARROW Define a name CONTROL + L Open the Smart Lookup pane CONTROL + OPTION + To do this Press Edit the selected cell F2 Create a table Insert a line break in a cell Insert special characters like symbols, including emoji CONTROL + Increase font size Decrease font size Align center Align left Display the Modify Cell Style dialog box Display the Format Cells dialog box Apply the general number format CONTROL + SHIFT + ~ Apply the currency format with two decimal places (negative numbers appear in red with parentheses) CONTROL + SHIFT + $ Apply the percentage format with no decimal places CONTROL + SHIFT + % Apply the exponential number format with two decimal places CONTROL + SHIFT + ^ Apply the date format with the day, month, and year CONTROL + SHIFT + # Apply the time format with the hour and minute, and indicate AM or PM CONTROL + SHIFT + @ Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values CONTROL + SHIFT + ! Apply the outline border around the selected cells Add an outline border to the right of the selection Add an outline border to the left of the selection Add an outline border to the top of the selection Add an outline border to the bottom of the selection Remove outline borders Apply or remove bold formatting Apply or remove italic formatting Apply or remove underscoring Apply or remove strikethrough formatting Hide a column Unhide a column Hide a row Unhide a row Edit the active cell CONTROL + 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 DELETE Paste text into the active cell Complete a cell entry RETURN Give selected cells the current cell's entry Enter a formula as an array formula Display the Formula Builder after you type a valid function name in a formula CONTROL + A To do this Press Copy Paste Cut Clear DELETE Delete the selection CONTROL + HYPHEN Undo the last action Hide a column Unhide a column Hide a row Unhide a row 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, TAB Move from right to left within the selection, SHIFT + TAB Move clockwise to the next corner of the selection CONTROL + PERIOD Group selected cells Ungroup selected cells * These shortcuts may move in another direction other than down or up. If you'd like to change the direction of these shortcuts using the mouse, on the Excel menu, click Preferences, click Edit, and then, under. After pressing Return, move selection, select the direction you want to move in. To do this Press Insert a new chart sheet. * F11 Cycle through chart object selection ARROW KEYS To do this Press Open the Sort dialog box Add or remove a filter Display the Filter list or PivotTable page OPTION + DOWN ARROW To do this Press Display or hide outline symbols CONTROL + 8 Hide selected rows CONTROL + 9 Unhide selected rows CONTROL + SHIFT + Opening parenthesis ( ( ) Hide selected columns CONTROL + ZERO Unhide selected columns CONTROL + SHIFT + Closing parenthesis ( ) ) Excel 2016 for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don't have to press the FN key every time you use a function key shortcut NOTE: Changing system function key preferences affects how the function keys work for your Mac, not just Excel. After changing this setting, you can still perform the special features printed on a function key. Just press the FN key. For example, to use the F12 key to change your volume, you would press FN+F12. If a function key doesn't work as you expect it to, press the FN key in addition to the function key. If you don't want to press the FN key each time, you can change your Apple system preferences: On the Apple menu, press System Preferences. Select Keyboard. On the Keyboard tab, select the check box for Use all F1, F2, etc. keys as standard function keys. To do this Press Display the Help window F1 Edit the selected cell F2 Insert or edit a cell comment SHIFT + F2 Open the Save dialog OPTION + F2 Open the Formula Builder SHIFT +F3 Open the Define Name dialog Close Display the Go To dialog F5 Display the Find dialog SHIFT + F5 Move to the Search Sheet dialog CONTROL + F5 Check spelling F7 Open the thesaurus SHIFT + F7 Extend the selection F8 Add to the selection SHIFT + F8 Display the Macro dialog OPTION +F8 Calculate all open workbooks F9 Calculate the active sheet SHIFT + F9 Minimize the active window CONTROL + F9 Display a contextual menu, or "right click" menu SHIFT + F10 Maximize or restore the active window CONTROL + F10 Insert a new chart sheet* F11 Insert a new sheet* SHIFT + F11 Insert an Excel 4.0 macro sheet Open Visual Basic OPTION + F11 Display the Save As dialog F12 Display the Open dialogFrequently used shortcuts
+ V
or
CONTROL + V + C
or
CONTROL + C + S
or
CONTROL + S + Z
or
CONTROL + Z + Y
or
CONTROL + Y
or + SHIFT+ Z
+ X
or
CONTROL + X + B
or
CONTROL + B + P
or
CONTROL + P + D
or
CONTROL + D + R
or
CONTROL + R + HYPHEN
or
CONTROL + HYPHEN + =
or
F9 + W
or
CONTROL + W + Q
or
F5 + 1
or
CONTROL + 1
or + SHIFT + H
+ CONTROL + V
or
CONTROL + OPTION + V
or + OPTION + V
+ U
+ I
or
CONTROL + I + N
or
CONTROL + N + SHIFT + P
+ SHIFT + S
or
F12
or + /
+ A
or + SHIFT + SPACEBAR
+ SHIFT + F
or
CONTROL + SHIFT + L + OPTION + R
+ O
or
CONTROL + O + F3
+ SHIFT + F3
+ P
or
CONTROL + P + P
or
CONTROL + PGet started
Shortcut conflicts
Work in windows and dialogs
+ OPTION + R
+ CONTROL + F
+ TAB
+ SHIFT + TAB
+ W
a Screen Shot file on your desktop. + SHIFT + 3
or + F10
+ H
Move and scroll in a sheet or workbook
+ ARROW KEY
On a MacBook, press FN + LEFT ARROW
On a MacBook, press CONTROL + FN + LEFT ARROW
On a MacBook, press CONTROL + FN + RIGHT ARROW
On a MacBook, press FN + DOWN ARROW
On a MacBook, press FN + UP ARROW
On a MacBook, press FN + OPTION + DOWN ARROW
On a MacBook, press FN + OPTION + UP ARROW
or
OPTION + RIGHT ARROW
or
OPTION + LEFT ARROW
or
SHIFT + F5 + F
Enter data on a sheet
+ RETURN
or
CONTROL + RETURN
Note: Some smaller keyboards do not have this key
On a MacBook, press FN + DELETE
Note: Some smaller keyboards do not have this key
On a MacBook, press CONTROL + FN + DELETE
On a MacBook, press FN + LEFT ARROW
or + D
or + R
Work in cells or the Formula bar
+ SHIFT + RETURN
or
CONTROL + SHIFT + RETURN + K
or
CONTROL + K + T
or
F4 + SHIFT + T
+ SEMICOLON (;)
+ L
Format and edit data
+ T
or
CONTROL + T + OPTION + RETURN
or
CONTROL + OPTION + RETURN + SPACEBAR
+ SHIFT + >
+ SHIFT + <
+ E
+ L
+ SHIFT + L
+ 1
+ OPTION + ZERO
+ OPTION + RIGHT ARROW
+ OPTION + LEFT ARROW
+ OPTION + UP ARROW
+ OPTION + DOWN ARROW
+ OPTION + HYPHEN
+ B
+ I
+ U
+ SHIFT + X
+ )
or
CONTROL + ) + SHIFT + )
or
CONTROL + SHIFT + ) + (
or
CONTROL + ( + SHIFT + (
or
CONTROL + SHIFT + ( + V
+ RETURN
or
CONTROL + RETURN + SHIFT + RETURN
or
CONTROL + SHIFT + RETURNSelect cells, columns, or rows
Work with a selection
+ C
or
CONTROL + V + V
or
CONTROL + V + X
or
CONTROL + X + Z
+ )
or
CONTROL + ) + SHIFT + )
or
CONTROL + SHIFT + ) + (
or
CONTROL + ( + SHIFT + (
or
CONTROL + SHIFT + (
or move down one cell if only one column is selected
or move up one cell if only one column is selected + SHIFT + K
+ SHIFT + J
Use charts
Sort, filter, and use PivotTable reports
+ SHIFT + R
+ SHIFT + F
or
CONTROL + SHIFT + L
field pop-up menu for the selected cellOutline data
Use function key shortcuts
The following table provides the function key shortcuts for Excel 2016 for Mac
For more information, please visit the Excel help center. +F3
+F4
or
CONTROL + OPTION + + R
or + F10
+ F11
+ F12