Hotkeys and shortcuts for Microsoft Excel 2016 (MacOS)

(Total 226)

+ V or Ctrl + V
Frequently used shortcuts
Paste
+ C or Ctrl + C
Frequently used shortcuts
Copy
Delete
Frequently used shortcuts
Clear
+ S or Ctrl + S
Frequently used shortcuts
Save
+ Z or Ctrl + Z
Frequently used shortcuts
Undo
+ Y or Ctrl + Y
Frequently used shortcuts
Redo
+ X or Ctrl + X
Frequently used shortcuts
Cut
+ B or Ctrl + B
Frequently used shortcuts
Bold
+ P or Ctrl + P
Frequently used shortcuts
Print
Option + F11
Frequently used shortcuts
Open Visual Basic
+ D or Ctrl + D
Frequently used shortcuts
Fill Down
+ R or Ctrl + R
Frequently used shortcuts
Fill Right
Ctrl + Shift + =
Frequently used shortcuts
Insert cells
+ - or Ctrl + - (hyphen)
Frequently used shortcuts
Delete cells
+ = or F9
Frequently used shortcuts
Calculate all open workbooks
+ W or Ctrl + W
Frequently used shortcuts
Close window
+ Q
Frequently used shortcuts
Quit Excel
Ctrl + G or F5
Frequently used shortcuts
Display the Go To dialog box
+ 1 or Ctrl + 1
Frequently used shortcuts
Display the Format Cells dialog box
Ctrl + H or + Shift + H
Frequently used shortcuts
Display the Replace dialog box
+ Ctrl + V or Ctrl + Option + V
Frequently used shortcuts
Paste Special
+ U
Frequently used shortcuts
Underline
+ I or Ctrl + I
Frequently used shortcuts
Italic
+ N or Ctrl + N
Frequently used shortcuts
New blank workbook
+ Shift + P
Frequently used shortcuts
New workbook from template
+ Shift + S or F12
Frequently used shortcuts
Display the Save As dialog box
F1 or + /
Frequently used shortcuts
Display the Help window
+ A or + Shift + Space
Frequently used shortcuts
Select All
+ Shift + F or Ctrl + Shift + L
Frequently used shortcuts
Add or remove a filter
+ Option + R or Ctrl + O
Frequently used shortcuts
Minimize or maximize the ribbon tabs
+ O
Frequently used shortcuts
Display the Open dialog box
F7
Frequently used shortcuts
Check spelling
Shift + F7
Frequently used shortcuts
Open the thesaurus
Shift + F3
Frequently used shortcuts
Display the Formula Builder
+ F3
Frequently used shortcuts
Open the Define Name dialog box
+ Shift + F3
Frequently used shortcuts
Open the Create names dialog box
Shift + F11
Frequently used shortcuts
Insert a new sheet *
+ P or Ctrl + P
Frequently used shortcuts
Print
+ P or Ctrl + P
Frequently used shortcuts
Print preview
Frequently used shortcuts
*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.
+ Option + R
Work in windows and dialogs
Expand or minimize the ribbon
+ Ctrl + F
Work in windows and dialogs
Switch to full screen view
+ Tab
Work in windows and dialogs
Switch to the next application
+ Shift + Tab
Work in windows and dialogs
Switch to the previous application
+ W
Work in windows and dialogs
Close the active workbook window
+ Shift + 3
Work in windows and dialogs
Copy the image of the screen and save it to a Screen Shot file on your desktop.
Ctrl + F9
Work in windows and dialogs
Minimize the active window
Ctrl + F10 or + F10
Work in windows and dialogs
Maximize or restore the active window
+ H
Work in windows and dialogs
Hide Excel.
Tab
Work in windows and dialogs
Move to the next box, option, control, or command
Shift + Tab
Work in windows and dialogs
Move to the previous box, option, control, or command
Esc
Work in windows and dialogs
Exit a dialog or cancel an action
Enter
Work in windows and dialogs
Perform the action assigned to the default command button (the button with the bold outline, often the OK button)
Esc
Work in windows and dialogs
Cancel the command and close
Arrow Keys
Move and scroll in a sheet or workbook
Move one cell up, down, left, or right
+ Arrow Key
Move and scroll in a sheet or workbook
Move to the edge of the current data region
Home
Move and scroll in a sheet or workbook
Move to the beginning of the row
Ctrl + Home
Move and scroll in a sheet or workbook
Move to the beginning of the sheet
Ctrl + End
Move and scroll in a sheet or workbook
Move to the last cell in use on the sheet
Page Down
Move and scroll in a sheet or workbook
Move down one screen
Page Up
Move and scroll in a sheet or workbook
Move up one screen
Option + Page Down
Move and scroll in a sheet or workbook
Move one screen to the right
Option + Page Up
Move and scroll in a sheet or workbook
Move one screen to the left
Ctrl + Page Down or Option + Arrow Right
Move and scroll in a sheet or workbook
Move to the next sheet in the workbook
Ctrl + Page Down or Option + Arrow Left
Move and scroll in a sheet or workbook
Move to the previous sheet in the workbook
Ctrl + Delete
Move and scroll in a sheet or workbook
Scroll to display the active cell
Ctrl + G
Move and scroll in a sheet or workbook
Display the Go To dialog box
Ctrl + F or Shift + F5
Move and scroll in a sheet or workbook
Display the Find dialog box
+ F
Move and scroll in a sheet or workbook
Access search (when in a cell or when a cell is selected)
Tab
Move and scroll in a sheet or workbook
Move between unlocked cells on a protected sheet
F2
Enter data on a sheet
Edit the selected cell
Enter
Enter data on a sheet
Complete a cell entry and move forward in the selection
Ctrl + Option + Enter
Enter data on a sheet
Start a new line in the same cell
+ Return or Ctrl + Enter
Enter data on a sheet
Fill the selected cell range with the text that you type
Shift + Enter
Enter data on a sheet
Complete a cell entry and move up in the selection
Tab
Enter data on a sheet
Complete a cell entry and move to the right in the selection
Shift + Tab
Enter data on a sheet
Complete a cell entry and move to the left in the selection
Esc
Enter data on a sheet
Cancel a cell entry
Delete
Enter data on a sheet
Delete the character to the left of the insertion point, or delete the selection
Enter data on a sheet
Delete the character to the right of the insertion point, or delete the selection
On a MacBook, press Fn + Delete
Enter data on a sheet
Note: Some smaller keyboards do not have this key
Enter data on a sheet
Note: Some smaller keyboards do not have this key
Arrow Keys
Enter data on a sheet
Move one character up, down, left, or right
Home
Enter data on a sheet
Move to the beginning of the line
Shift + F2
Enter data on a sheet
Insert a comment
Shift + F2
Enter data on a sheet
Open and edit a cell comment
Ctrl + D or + D
Enter data on a sheet
Fill down
Ctrl + R or + R
Enter data on a sheet
Fill to the right
Ctrl + L
Enter data on a sheet
Define a name
F2
Work in cells or the Formula bar
Edit the selected cell
Delete
Work in cells or the Formula bar
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
Enter
Work in cells or the Formula bar
Complete a cell entry
+ Shift + Return or Ctrl + Shift + Enter
Work in cells or the Formula bar
Enter a formula as an array formula
Esc
Work in cells or the Formula bar
Cancel an entry in the cell or formula bar
Ctrl + A
Work in cells or the Formula bar
Display the Formula Builder after you type a valid function name in a formula
+ K or Ctrl + K
Work in cells or the Formula bar
Insert a hyperlink
Ctrl + U
Work in cells or the Formula bar
Edit the active cell and position the insertion point at the end of the line
Shift + F3
Work in cells or the Formula bar
Open the Formula Builder
Shift + F9
Work in cells or the Formula bar
Calculate the active sheet
Shift + F10
Work in cells or the Formula bar
Display a contextual menu
=
Work in cells or the Formula bar
Start a formula
+ T or F4
Work in cells or the Formula bar
Toggle the formula reference style between absolute, relative, and mixed
+ Shift + T
Work in cells or the Formula bar
Insert the AutoSum formula
Ctrl + ; (semicolon)
Work in cells or the Formula bar
Enter the date
+ ; (semicolon)
Work in cells or the Formula bar
Enter the time
Ctrl + Shift + " (inchmark)
Work in cells or the Formula bar
Copy the value from the cell above the active cell into the cell or the formula bar
Ctrl + ` (grave accent)
Work in cells or the Formula bar
Alternate between displaying cell values and displaying cell formulas
Ctrl + ' (apostrophe))
Work in cells or the Formula bar
Copy a formula from the cell above the active cell into the cell or the formula bar
Ctrl + Option + Arrow Down
Work in cells or the Formula bar
Display the AutoComplete list
Ctrl + L
Work in cells or the Formula bar
Define a name
Ctrl + Option + + L
Work in cells or the Formula bar
Open the Smart Lookup pane
F2
Format and edit data
Edit the selected cell
+ T or Ctrl + T
Format and edit data
Create a table
+ Option + Return or Ctrl + Option + Enter
Format and edit data
Insert a line break in a cell
Ctrl + Spacebar or + Space
Format and edit data
Insert special characters like symbols, including emoji
+ Shift + >
Format and edit data
Increase font size
+ Shift + <
Format and edit data
Decrease font size
+ E
Format and edit data
Align center
+ L
Format and edit data
Align left
+ Shift + L
Format and edit data
Display the Modify Cell Style dialog box
+ 1
Format and edit data
Display the Format Cells dialog box
Ctrl + Shift + ~
Format and edit data
Apply the general number format
Ctrl + Shift + $
Format and edit data
Apply the currency format with two decimal places (negative numbers appear in red with parentheses)
Ctrl + Shift + %
Format and edit data
Apply the percentage format with no decimal places
Ctrl + Shift + ^
Format and edit data
Apply the exponential number format with two decimal places
Ctrl + Shift + #
Format and edit data
Apply the date format with the day, month, and year
Ctrl + Shift + @
Format and edit data
Apply the time format with the hour and minute, and indicate AM or PM
Ctrl + Shift + !
Format and edit data
Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values
+ Option + 0
Format and edit data
Apply the outline border around the selected cells
+ Option + Arrow Right
Format and edit data
Add an outline border to the right of the selection
+ Option + Arrow Left
Format and edit data
Add an outline border to the left of the selection
+ Option + Arrow Up
Format and edit data
Add an outline border to the top of the selection
+ Option + Arrow Down
Format and edit data
Add an outline border to the bottom of the selection
+ Option + - (hyphen)
Format and edit data
Remove outline borders
+ B
Format and edit data
Apply or remove bold formatting
+ I
Format and edit data
Apply or remove italic formatting
+ U
Format and edit data
Apply or remove underscoring
+ Shift + X
Format and edit data
Apply or remove strikethrough formatting
+ ) or Ctrl + )
Format and edit data
Hide a column
+ Shift + ) or Ctrl + Shift + )
Format and edit data
Unhide a column
+ ( or Ctrl + (
Format and edit data
Hide a row
+ Shift + ( or Ctrl + Shift + (
Format and edit data
Unhide a row
Ctrl + U
Format and edit data
Edit the active cell
Esc
Format and edit data
Cancel an entry in the cell or the formula bar
Delete
Format and edit data
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
+ V
Format and edit data
Paste text into the active cell
Enter
Format and edit data
Complete a cell entry
+ Return or Ctrl + Enter
Format and edit data
Give selected cells the current cell's entry
+ Shift + Return or Ctrl + Shift + Enter
Format and edit data
Enter a formula as an array formula
Ctrl + A
Format and edit data
Display the Formula Builder after you type a valid function name in a formula
Shift + Arrow Key
Select cells, columns, or rows
Extend the selection by one cell
+ Shift + Arrow Key
Select cells, columns, or rows
Extend the selection to the last nonblank cell in the same column or row as the active cell
Shift + Home
Select cells, columns, or rows
Extend the selection to the beginning of the row
Ctrl + Shift + Home
Select cells, columns, or rows
Extend the selection to the beginning of the sheet
Ctrl + Shift + End
Select cells, columns, or rows
Extend the selection to the last cell used on the sheet (lower-right corner)
Ctrl + Space
Select cells, columns, or rows
Select the entire column
Shift + Space
Select cells, columns, or rows
Select the entire row
+ A
Select cells, columns, or rows
Select the entire sheet
+ Shift + * (asterisk)
Select cells, columns, or rows
Select only visible cells
Shift + Delete
Select cells, columns, or rows
Select only the active cell when multiple cells are selected
Shift + Page Down
Select cells, columns, or rows
Extend the selection down one screen
Shift + Page Up
Select cells, columns, or rows
Extend the selection up one screen
Ctrl + 6
Select cells, columns, or rows
Alternate between hiding objects, displaying objects, and displaying placeholders for objects
F8
Select cells, columns, or rows
Turn on the capability to extend a selection by using the arrow keys
Shift + F8
Select cells, columns, or rows
Add another range of cells to the selection
Ctrl + /
Select cells, columns, or rows
Select the current array, which is the array that the active cell belongs to.
Ctrl + \
Select cells, columns, or rows
Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell.
Ctrl + Shift + [
Select cells, columns, or rows
Select only cells that are directly referred to by formulas in the selection
Ctrl + Shift + {
Select cells, columns, or rows
Select all cells that are directly or indirectly referred to by formulas in the selection
Ctrl + ]
Select cells, columns, or rows
Select only cells with formulas that refer directly to the active cell
Ctrl + Shift + }
Select cells, columns, or rows
Select all cells with formulas that refer directly or indirectly to the active cell
+ C or Ctrl + C
Work with a selection
Copy
+ V or Ctrl + V
Work with a selection
Paste
+ X or Ctrl + X
Work with a selection
Cut
Delete
Work with a selection
Clear
Ctrl + - (hyphen)
Work with a selection
Delete the selection
+ Z
Work with a selection
Undo the last action
+ ) or Ctrl + )
Work with a selection
Hide a column
+ Shift + ) or Ctrl + Shift + )
Work with a selection
Unhide a column
+ ( or Ctrl + (
Work with a selection
Hide a row
+ Shift + ( or Ctrl + Shift + (
Work with a selection
Unhide a row
Enter
Work with a selection
Move from top to bottom within the selection (down)*
Shift + Enter
Work with a selection
Move from bottom to top within the selection (up)*
Tab
Work with a selection
Move from left to right within the selection, or move down one cell if only one column is selected
Shift + Tab
Work with a selection
Move from right to left within the selection, or move down one cell if only one column is selected
Ctrl + . (period)
Work with a selection
Move clockwise to the next corner of the selection
+ Shift + K
Work with a selection
Group selected cells
+ Shift + J
Work with a selection
Ungroup selected cells
Work with a selection
*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.
F11
Use charts
Insert a new chart sheet.
ArrowKeys
Use charts
Cycle through chart object selection
+ Shift + R
Sort, filter, and use PivotTable reports
Open the Sort dialog box
+ Shift + F or Ctrl + Shift + L
Sort, filter, and use PivotTable reports
Add or remove a filter
Option + Arrow Down
Sort, filter, and use PivotTable reports
Display the Filter list or PivotTable page field pop-up menu for the selected cell
Ctrl + 8
Outline data
Display or hide outline symbols
Ctrl + 9
Outline data
Hide selected rows
Ctrl + Shift + ( (opening parenthesis)
Outline data
Unhide selected rows
Ctrl + 0 (zero)
Outline data
Hide selected columns
Ctrl + Shift + ) (closing parenthesis)
Outline data
Unhide selected columns
F1
The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Help window
F2
The following table provides the function key shortcuts for Excel 2016 for Mac*
Edit the selected cell
Shift + F2
The following table provides the function key shortcuts for Excel 2016 for Mac*
Insert or edit a cell comment
Option + F2
The following table provides the function key shortcuts for Excel 2016 for Mac*
Open the Save dialog
Shift +F3
The following table provides the function key shortcuts for Excel 2016 for Mac*
Open the Formula Builder
+ F3
The following table provides the function key shortcuts for Excel 2016 for Mac*
Open the Define Name dialog
+ F4
The following table provides the function key shortcuts for Excel 2016 for Mac*
Close
F5
The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Go To dialog
Shift + F5
The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Find dialog
Ctrl + F5
The following table provides the function key shortcuts for Excel 2016 for Mac*
Move to the Search Sheet dialog
F7
The following table provides the function key shortcuts for Excel 2016 for Mac*
Check spelling
Shift + F7 or Ctrl + Option + + R
The following table provides the function key shortcuts for Excel 2016 for Mac*
Open the thesaurus
F8
The following table provides the function key shortcuts for Excel 2016 for Mac*
Extend the selection
Shift + F8
The following table provides the function key shortcuts for Excel 2016 for Mac*
Add to the selection
Option + F8
The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Macro dialog
F9
The following table provides the function key shortcuts for Excel 2016 for Mac*
Calculate all open workbooks
Shift + F9
The following table provides the function key shortcuts for Excel 2016 for Mac*
Calculate the active sheet
Ctrl + F9
The following table provides the function key shortcuts for Excel 2016 for Mac*
Minimize the active window
Shift + F10
The following table provides the function key shortcuts for Excel 2016 for Mac*
Display a contextual menu, or "right click" menu
Ctrl + F10 or + F10
The following table provides the function key shortcuts for Excel 2016 for Mac*
Maximize or restore the active window
F11
The following table provides the function key shortcuts for Excel 2016 for Mac*
Insert a new chart sheet*
Shift + F11
The following table provides the function key shortcuts for Excel 2016 for Mac*
Insert a new sheet*
+ F11
The following table provides the function key shortcuts for Excel 2016 for Mac*
Insert an Excel 4.0 macro sheet
Option + F11
The following table provides the function key shortcuts for Excel 2016 for Mac*
Open Visual Basic
F12
The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Save As dialog
+ F12
The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Open dialog
The following table provides the function key shortcuts for Excel 2016 for Mac*
*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