Microsoft Excel 2016 (MacOS)

Work in cells or the Formula bar

Display the AutoComplete list

Ctrl + Option + Arrow Down

All hotkeys for Microsoft Excel 2016 (MacOS)

Frequently used shortcuts
Paste

+ V or Ctrl + V

Frequently used shortcuts
Copy

+ C or Ctrl + C

Frequently used shortcuts
Clear

Delete

Frequently used shortcuts
Save

+ S or Ctrl + S

Frequently used shortcuts
Undo

+ Z or Ctrl + Z

Frequently used shortcuts
Redo

+ Y or Ctrl + Y

Frequently used shortcuts
Cut

+ X or Ctrl + X

Frequently used shortcuts
Bold

+ B or Ctrl + B

Frequently used shortcuts
Print

+ P or Ctrl + P

Frequently used shortcuts
Open Visual Basic

Option + F11

Frequently used shortcuts
Fill Down

+ D or Ctrl + D

Frequently used shortcuts
Fill Right

+ R or Ctrl + R

Frequently used shortcuts
Insert cells

Ctrl + Shift + =

Frequently used shortcuts
Delete cells

+ - or Ctrl + - (hyphen)

Frequently used shortcuts
Calculate all open workbooks

+ = or F9

Frequently used shortcuts
Close window

+ W or Ctrl + W

Frequently used shortcuts
Quit Excel

+ Q

Frequently used shortcuts
Display the Go To dialog box

Ctrl + G or F5

Frequently used shortcuts
Display the Format Cells dialog box

+ 1 or Ctrl + 1

Frequently used shortcuts
Display the Replace dialog box

Ctrl + H or + Shift + H

Frequently used shortcuts
Paste Special

+ Ctrl + V or Ctrl + Option + V

Frequently used shortcuts
Underline

+ U

Frequently used shortcuts
Italic

+ I or Ctrl + I

Frequently used shortcuts
New blank workbook

+ N or Ctrl + N

Frequently used shortcuts
New workbook from template

+ Shift + P

Frequently used shortcuts
Display the Save As dialog box

+ Shift + S or F12

Frequently used shortcuts
Display the Help window

F1 or + /

Frequently used shortcuts
Select All

+ A or + Shift + Space

Frequently used shortcuts
Add or remove a filter

+ Shift + F or Ctrl + Shift + L

Frequently used shortcuts
Minimize or maximize the ribbon tabs

+ Option + R or Ctrl + O

Frequently used shortcuts
Display the Open dialog box

+ O

Frequently used shortcuts
Check spelling

F7

Frequently used shortcuts
Open the thesaurus

Shift + F7

Frequently used shortcuts
Display the Formula Builder

Shift + F3

Frequently used shortcuts
Open the Define Name dialog box

+ F3

Frequently used shortcuts
Open the Create names dialog box

+ Shift + F3

Frequently used shortcuts
Insert a new sheet *

Shift + F11

Frequently used shortcuts
Print

+ P or Ctrl + P

Frequently used shortcuts
Print preview

+ P or Ctrl + P

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.

Work in windows and dialogs
Expand or minimize the ribbon

+ Option + R

Work in windows and dialogs
Switch to full screen view

+ Ctrl + F

Work in windows and dialogs
Switch to the next application

+ Tab

Work in windows and dialogs
Switch to the previous application

+ Shift + Tab

Work in windows and dialogs
Close the active workbook window

+ W

Work in windows and dialogs
Copy the image of the screen and save it to a Screen Shot file on your desktop.

+ Shift + 3

Work in windows and dialogs
Minimize the active window

Ctrl + F9

Work in windows and dialogs
Maximize or restore the active window

Ctrl + F10 or + F10

Work in windows and dialogs
Hide Excel.

+ H

Work in windows and dialogs
Move to the next box, option, control, or command

Tab

Work in windows and dialogs
Move to the previous box, option, control, or command

Shift + Tab

Work in windows and dialogs
Exit a dialog or cancel an action

Esc

Work in windows and dialogs
Perform the action assigned to the default command button (the button with the bold outline, often the OK button)

Enter

Work in windows and dialogs
Cancel the command and close

Esc

Move and scroll in a sheet or workbook
Move one cell up, down, left, or right

Arrow Keys

Move and scroll in a sheet or workbook
Move to the edge of the current data region

+ Arrow Key

Move and scroll in a sheet or workbook
Move to the beginning of the row

Home

Move and scroll in a sheet or workbook
Move to the beginning of the sheet

Ctrl + Home

Move and scroll in a sheet or workbook
Move to the last cell in use on the sheet

Ctrl + End

Move and scroll in a sheet or workbook
Move down one screen

Page Down

Move and scroll in a sheet or workbook
Move up one screen

Page Up

Move and scroll in a sheet or workbook
Move one screen to the right

Option + Page Down

Move and scroll in a sheet or workbook
Move one screen to the left

Option + Page Up

Move and scroll in a sheet or workbook
Move to the next sheet in the workbook

Ctrl + Page Down or Option + Arrow Right

Move and scroll in a sheet or workbook
Move to the previous sheet in the workbook

Ctrl + Page Down or Option + Arrow Left

Move and scroll in a sheet or workbook
Scroll to display the active cell

Ctrl + Delete

Move and scroll in a sheet or workbook
Display the Go To dialog box

Ctrl + G

Move and scroll in a sheet or workbook
Display the Find dialog box

Ctrl + F or Shift + F5

Move and scroll in a sheet or workbook
Access search (when in a cell or when a cell is selected)

+ F

Move and scroll in a sheet or workbook
Move between unlocked cells on a protected sheet

Tab

Enter data on a sheet
Edit the selected cell

F2

Enter data on a sheet
Complete a cell entry and move forward in the selection

Enter

Enter data on a sheet
Start a new line in the same cell

Ctrl + Option + Enter

Enter data on a sheet
Fill the selected cell range with the text that you type

+ Return or Ctrl + Enter

Enter data on a sheet
Complete a cell entry and move up in the selection

Shift + Enter

Enter data on a sheet
Complete a cell entry and move to the right in the selection

Tab

Enter data on a sheet
Complete a cell entry and move to the left in the selection

Shift + Tab

Enter data on a sheet
Cancel a cell entry

Esc

Enter data on a sheet
Delete the character to the left of the insertion point, or delete the selection

Delete

Enter data on a sheet
Delete the character to the right of the insertion point, or delete the selection

Enter data on a sheet
Note: Some smaller keyboards do not have this key

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
Move one character up, down, left, or right

Arrow Keys

Enter data on a sheet
Move to the beginning of the line

Home

Enter data on a sheet
Insert a comment

Shift + F2

Enter data on a sheet
Open and edit a cell comment

Shift + F2

Enter data on a sheet
Fill down

Ctrl + D or + D

Enter data on a sheet
Fill to the right

Ctrl + R or + R

Enter data on a sheet
Define a name

Ctrl + L

Work in cells or the Formula bar
Edit the selected cell

F2

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

Delete

Work in cells or the Formula bar
Complete a cell entry

Enter

Work in cells or the Formula bar
Enter a formula as an array formula

+ Shift + Return or Ctrl + Shift + Enter

Work in cells or the Formula bar
Cancel an entry in the cell or formula bar

Esc

Work in cells or the Formula bar
Display the Formula Builder after you type a valid function name in a formula

Ctrl + A

Work in cells or the Formula bar
Insert a hyperlink

+ K or Ctrl + K

Work in cells or the Formula bar
Edit the active cell and position the insertion point at the end of the line

Ctrl + U

Work in cells or the Formula bar
Open the Formula Builder

Shift + F3

Work in cells or the Formula bar
Calculate the active sheet

Shift + F9

Work in cells or the Formula bar
Display a contextual menu

Shift + F10

Work in cells or the Formula bar
Start a formula

=

Work in cells or the Formula bar
Toggle the formula reference style between absolute, relative, and mixed

+ T or F4

Work in cells or the Formula bar
Insert the AutoSum formula

+ Shift + T

Work in cells or the Formula bar
Enter the date

Ctrl + ; (semicolon)

Work in cells or the Formula bar
Enter the time

+ ; (semicolon)

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 + Shift + " (inchmark)

Work in cells or the Formula bar
Alternate between displaying cell values and displaying cell formulas

Ctrl + ` (grave accent)

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 + ' (apostrophe))

Work in cells or the Formula bar
Display the AutoComplete list

Ctrl + Option + Arrow Down

Work in cells or the Formula bar
Define a name

Ctrl + L

Work in cells or the Formula bar
Open the Smart Lookup pane

Ctrl + Option + + L

Format and edit data
Edit the selected cell

F2

Format and edit data
Create a table

+ T or Ctrl + T

Format and edit data
Insert a line break in a cell

+ Option + Return or Ctrl + Option + Enter

Format and edit data
Insert special characters like symbols, including emoji

Ctrl + Spacebar or + Space

Format and edit data
Increase font size

+ Shift + >

Format and edit data
Decrease font size

+ Shift + <

Format and edit data
Align center

+ E

Format and edit data
Align left

+ L

Format and edit data
Display the Modify Cell Style dialog box

+ Shift + L

Format and edit data
Display the Format Cells dialog box

+ 1

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

Ctrl + Shift + !

Format and edit data
Apply the outline border around the selected cells

+ Option + 0

Format and edit data
Add an outline border to the right of the selection

+ Option + Arrow Right

Format and edit data
Add an outline border to the left of the selection

+ Option + Arrow Left

Format and edit data
Add an outline border to the top of the selection

+ Option + Arrow Up

Format and edit data
Add an outline border to the bottom of the selection

+ Option + Arrow Down

Format and edit data
Remove outline borders

+ Option + - (hyphen)

Format and edit data
Apply or remove bold formatting

+ B

Format and edit data
Apply or remove italic formatting

+ I

Format and edit data
Apply or remove underscoring

+ U

Format and edit data
Apply or remove strikethrough formatting

+ Shift + X

Format and edit data
Hide a column

+ ) or Ctrl + )

Format and edit data
Unhide a column

+ Shift + ) or Ctrl + Shift + )

Format and edit data
Hide a row

+ ( or Ctrl + (

Format and edit data
Unhide a row

+ Shift + ( or Ctrl + Shift + (

Format and edit data
Edit the active cell

Ctrl + U

Format and edit data
Cancel an entry in the cell or the formula bar

Esc

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

Delete

Format and edit data
Paste text into the active cell

+ V

Format and edit data
Complete a cell entry

Enter

Format and edit data
Give selected cells the current cell's entry

+ Return or Ctrl + Enter

Format and edit data
Enter a formula as an array formula

+ Shift + Return or Ctrl + Shift + Enter

Format and edit data
Display the Formula Builder after you type a valid function name in a formula

Ctrl + A

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 + Arrow Key

Select cells, columns, or rows
Extend the selection to the beginning of the row

Shift + Home

Select cells, columns, or rows
Extend the selection to the beginning of the sheet

Ctrl + Shift + Home

Select cells, columns, or rows
Extend the selection to the last cell used on the sheet (lower-right corner)

Ctrl + Shift + End

Select cells, columns, or rows
Select the entire column

Ctrl + Space

Select cells, columns, or rows
Select the entire row

Shift + Space

Select cells, columns, or rows
Select the entire sheet

+ A

Select cells, columns, or rows
Select only visible cells

+ Shift + * (asterisk)

Select cells, columns, or rows
Select only the active cell when multiple cells are selected

Shift + Delete

Select cells, columns, or rows
Extend the selection down one screen

Shift + Page Down

Select cells, columns, or rows
Extend the selection up one screen

Shift + Page Up

Select cells, columns, or rows
Alternate between hiding objects, displaying objects, and displaying placeholders for objects

Ctrl + 6

Select cells, columns, or rows
Turn on the capability to extend a selection by using the arrow keys

F8

Select cells, columns, or rows
Add another range of cells to the selection

Shift + F8

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 + \

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 + Shift + {

Select cells, columns, or rows
Select only cells with formulas that refer directly to the active cell

Ctrl + ]

Select cells, columns, or rows
Select all cells with formulas that refer directly or indirectly to the active cell

Ctrl + Shift + }

Work with a selection
Copy

+ C or Ctrl + C

Work with a selection
Paste

+ V or Ctrl + V

Work with a selection
Cut

+ X or Ctrl + X

Work with a selection
Clear

Delete

Work with a selection
Delete the selection

Ctrl + - (hyphen)

Work with a selection
Undo the last action

+ Z

Work with a selection
Hide a column

+ ) or Ctrl + )

Work with a selection
Unhide a column

+ Shift + ) or Ctrl + Shift + )

Work with a selection
Hide a row

+ ( or Ctrl + (

Work with a selection
Unhide a row

+ Shift + ( or Ctrl + Shift + (

Work with a selection
Move from top to bottom within the selection (down)*

Enter

Work with a selection
Move from bottom to top within the selection (up)*

Shift + Enter

Work with a selection
Move from left to right within the selection, or move down one cell if only one column is selected

Tab

Work with a selection
Move from right to left within the selection, or move down one cell if only one column is selected

Shift + Tab

Work with a selection
Move clockwise to the next corner of the selection

Ctrl + . (period)

Work with a selection
Group selected cells

+ Shift + K

Work with a selection
Ungroup selected cells

+ Shift + J

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.

Use charts
Insert a new chart sheet.

F11

Use charts
Cycle through chart object selection

ArrowKeys

Sort, filter, and use PivotTable reports
Open the Sort dialog box

+ Shift + R

Sort, filter, and use PivotTable reports
Add or remove a filter

+ Shift + F or Ctrl + Shift + L

Sort, filter, and use PivotTable reports
Display the Filter list or PivotTable page field pop-up menu for the selected cell

Option + Arrow Down

Outline data
Display or hide outline symbols

Ctrl + 8

Outline data
Hide selected rows

Ctrl + 9

Outline data
Unhide selected rows

Ctrl + Shift + ( (opening parenthesis)

Outline data
Hide selected columns

Ctrl + 0 (zero)

Outline data
Unhide selected columns

Ctrl + Shift + ) (closing parenthesis)

The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Help window

F1

The following table provides the function key shortcuts for Excel 2016 for Mac*
Edit the selected cell

F2

The following table provides the function key shortcuts for Excel 2016 for Mac*
Insert or edit a cell comment

Shift + F2

The following table provides the function key shortcuts for Excel 2016 for Mac*
Open the Save dialog

Option + F2

The following table provides the function key shortcuts for Excel 2016 for Mac*
Open the Formula Builder

Shift +F3

The following table provides the function key shortcuts for Excel 2016 for Mac*
Open the Define Name dialog

+ F3

The following table provides the function key shortcuts for Excel 2016 for Mac*
Close

+ F4

The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Go To dialog

F5

The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Find dialog

Shift + F5

The following table provides the function key shortcuts for Excel 2016 for Mac*
Move to the Search Sheet dialog

Ctrl + F5

The following table provides the function key shortcuts for Excel 2016 for Mac*
Check spelling

F7

The following table provides the function key shortcuts for Excel 2016 for Mac*
Open the thesaurus

Shift + F7 or Ctrl + Option + + R

The following table provides the function key shortcuts for Excel 2016 for Mac*
Extend the selection

F8

The following table provides the function key shortcuts for Excel 2016 for Mac*
Add to the selection

Shift + F8

The following table provides the function key shortcuts for Excel 2016 for Mac*
Display the Macro dialog

Option + F8

The following table provides the function key shortcuts for Excel 2016 for Mac*
Calculate all open workbooks

F9

The following table provides the function key shortcuts for Excel 2016 for Mac*
Calculate the active sheet

Shift + F9

The following table provides the function key shortcuts for Excel 2016 for Mac*
Minimize the active window

Ctrl + F9

The following table provides the function key shortcuts for Excel 2016 for Mac*
Display a contextual menu, or "right click" menu

Shift + F10

The following table provides the function key shortcuts for Excel 2016 for Mac*
Maximize or restore the active window

Ctrl + F10 or + F10

The following table provides the function key shortcuts for Excel 2016 for Mac*
Insert a new chart sheet*

F11

The following table provides the function key shortcuts for Excel 2016 for Mac*
Insert a new sheet*

Shift + F11

The following table provides the function key shortcuts for Excel 2016 for Mac*
Insert an Excel 4.0 macro sheet

+ F11

The following table provides the function key shortcuts for Excel 2016 for Mac*
Open Visual Basic

Option + F11

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

+ F12

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

Similar combinations for other applications


Microsoft Excel 2011 (MacOS)
Display the AutoComplete list
Working in cells or the Formula bar

Ctrl + Option + Arrow Down


Cloud9 (MacOS)
Add Cursor Below
Cursor

Ctrl + Option + Arrow Down


Adobe After Effects CS5 (Windows)
Increase / decrease leading by 10 units
Text

Ctrl + Option + Arrow Down / Arrow Up