Microsoft Excel 2016 (MacOS)
Frequently used shortcuts
Display the Replace dialog box
Ctrl + H or ⌘ + Shift + H
All hotkeys for Microsoft Excel 2016 (MacOS)
Frequently used shortcutsPaste |
⌘ + V or Ctrl + V |
Frequently used shortcutsCopy |
⌘ + C or Ctrl + C |
Frequently used shortcutsClear |
Delete |
Frequently used shortcutsSave |
⌘ + S or Ctrl + S |
Frequently used shortcutsUndo |
⌘ + Z or Ctrl + Z |
Frequently used shortcutsRedo |
⌘ + Y or Ctrl + Y |
Frequently used shortcutsCut |
⌘ + X or Ctrl + X |
Frequently used shortcutsBold |
⌘ + B or Ctrl + B |
Frequently used shortcuts |
⌘ + P or Ctrl + P |
Frequently used shortcutsOpen Visual Basic |
Option + F11 |
Frequently used shortcutsFill Down |
⌘ + D or Ctrl + D |
Frequently used shortcutsFill Right |
⌘ + R or Ctrl + R |
Frequently used shortcutsInsert cells |
Ctrl + Shift + = |
Frequently used shortcutsDelete cells |
⌘ + - or Ctrl + - (hyphen) |
Frequently used shortcutsCalculate all open workbooks |
⌘ + = or F9 |
Frequently used shortcutsClose window |
⌘ + W or Ctrl + W |
Frequently used shortcutsQuit Excel |
⌘ + Q |
Frequently used shortcutsDisplay the Go To dialog box |
Ctrl + G or F5 |
Frequently used shortcutsDisplay the Format Cells dialog box |
⌘ + 1 or Ctrl + 1 |
Frequently used shortcutsDisplay the Replace dialog box |
Ctrl + H or ⌘ + Shift + H |
Frequently used shortcutsPaste Special |
⌘ + Ctrl + V or Ctrl + Option + V |
Frequently used shortcutsUnderline |
⌘ + U |
Frequently used shortcutsItalic |
⌘ + I or Ctrl + I |
Frequently used shortcutsNew blank workbook |
⌘ + N or Ctrl + N |
Frequently used shortcutsNew workbook from template |
⌘ + Shift + P |
Frequently used shortcutsDisplay the Save As dialog box |
⌘ + Shift + S or F12 |
Frequently used shortcutsDisplay the Help window |
F1 or ⌘ + / |
Frequently used shortcutsSelect All |
⌘ + A or ⌘ + Shift + Space |
Frequently used shortcutsAdd or remove a filter |
⌘ + Shift + F or Ctrl + Shift + L |
Frequently used shortcutsMinimize or maximize the ribbon tabs |
⌘ + Option + R or Ctrl + O |
Frequently used shortcutsDisplay the Open dialog box |
⌘ + O |
Frequently used shortcutsCheck spelling |
F7 |
Frequently used shortcutsOpen the thesaurus |
Shift + F7 |
Frequently used shortcutsDisplay the Formula Builder |
Shift + F3 |
Frequently used shortcutsOpen the Define Name dialog box |
⌘ + F3 |
Frequently used shortcutsOpen the Create names dialog box |
⌘ + Shift + F3 |
Frequently used shortcutsInsert a new sheet * |
Shift + F11 |
Frequently used shortcuts |
⌘ + P or Ctrl + P |
Frequently used shortcutsPrint 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 dialogsExpand or minimize the ribbon |
⌘ + Option + R |
Work in windows and dialogsSwitch to full screen view |
⌘ + Ctrl + F |
Work in windows and dialogsSwitch to the next application |
⌘ + Tab |
Work in windows and dialogsSwitch to the previous application |
⌘ + Shift + Tab |
Work in windows and dialogsClose the active workbook window |
⌘ + W |
Work in windows and dialogsCopy the image of the screen and save it to a Screen Shot file on your desktop. |
⌘ + Shift + 3 |
Work in windows and dialogsMinimize the active window |
Ctrl + F9 |
Work in windows and dialogsMaximize or restore the active window |
Ctrl + F10 or ⌘ + F10 |
Work in windows and dialogsHide Excel. |
⌘ + H |
Work in windows and dialogsMove to the next box, option, control, or command |
Tab |
Work in windows and dialogsMove to the previous box, option, control, or command |
Shift + Tab |
Work in windows and dialogsExit a dialog or cancel an action |
Esc |
Work in windows and dialogsPerform the action assigned to the default command button (the button with the bold outline, often the OK button) |
Enter |
Work in windows and dialogsCancel the command and close |
Esc |
Move and scroll in a sheet or workbookMove one cell up, down, left, or right |
Arrow Keys |
Move and scroll in a sheet or workbookMove to the edge of the current data region |
⌘ + Arrow Key |
Move and scroll in a sheet or workbookMove to the beginning of the row |
Home |
Move and scroll in a sheet or workbookMove to the beginning of the sheet |
Ctrl + Home |
Move and scroll in a sheet or workbookMove to the last cell in use on the sheet |
Ctrl + End |
Move and scroll in a sheet or workbookMove down one screen |
Page Down |
Move and scroll in a sheet or workbookMove up one screen |
Page Up |
Move and scroll in a sheet or workbookMove one screen to the right |
Option + Page Down |
Move and scroll in a sheet or workbookMove one screen to the left |
Option + Page Up |
Move and scroll in a sheet or workbookMove to the next sheet in the workbook |
Ctrl + Page Down or Option + Arrow Right |
Move and scroll in a sheet or workbookMove to the previous sheet in the workbook |
Ctrl + Page Down or Option + Arrow Left |
Move and scroll in a sheet or workbookScroll to display the active cell |
Ctrl + Delete |
Move and scroll in a sheet or workbookDisplay the Go To dialog box |
Ctrl + G |
Move and scroll in a sheet or workbookDisplay the Find dialog box |
Ctrl + F or Shift + F5 |
Move and scroll in a sheet or workbookAccess search (when in a cell or when a cell is selected) |
⌘ + F |
Move and scroll in a sheet or workbookMove between unlocked cells on a protected sheet |
Tab |
Enter data on a sheetEdit the selected cell |
F2 |
Enter data on a sheetComplete a cell entry and move forward in the selection |
Enter |
Enter data on a sheetStart a new line in the same cell |
Ctrl + Option + Enter |
Enter data on a sheetFill the selected cell range with the text that you type |
⌘ + Return or Ctrl + Enter |
Enter data on a sheetComplete a cell entry and move up in the selection |
Shift + Enter |
Enter data on a sheetComplete a cell entry and move to the right in the selection |
Tab |
Enter data on a sheetComplete a cell entry and move to the left in the selection |
Shift + Tab |
Enter data on a sheetCancel a cell entry |
Esc |
Enter data on a sheetDelete the character to the left of the insertion point, or delete the selection |
Delete |
Enter data on a sheetDelete the character to the right of the insertion point, or delete the selection |
|
Enter data on a sheetNote: Some smaller keyboards do not have this key |
On a MacBook, press Fn + Delete |
Enter data on a sheetNote: Some smaller keyboards do not have this key |
|
Enter data on a sheetMove one character up, down, left, or right |
Arrow Keys |
Enter data on a sheetMove to the beginning of the line |
Home |
Enter data on a sheetInsert a comment |
Shift + F2 |
Enter data on a sheetOpen and edit a cell comment |
Shift + F2 |
Enter data on a sheetFill down |
Ctrl + D or ⌘ + D |
Enter data on a sheetFill to the right |
Ctrl + R or ⌘ + R |
Enter data on a sheetDefine a name |
Ctrl + L |
Work in cells or the Formula barEdit the selected cell |
F2 |
Work in cells or the Formula barEdit 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 barComplete a cell entry |
Enter |
Work in cells or the Formula barEnter a formula as an array formula |
⌘ + Shift + Return or Ctrl + Shift + Enter |
Work in cells or the Formula barCancel an entry in the cell or formula bar |
Esc |
Work in cells or the Formula barDisplay the Formula Builder after you type a valid function name in a formula |
Ctrl + A |
Work in cells or the Formula barInsert a hyperlink |
⌘ + K or Ctrl + K |
Work in cells or the Formula barEdit the active cell and position the insertion point at the end of the line |
Ctrl + U |
Work in cells or the Formula barOpen the Formula Builder |
Shift + F3 |
Work in cells or the Formula barCalculate the active sheet |
Shift + F9 |
Work in cells or the Formula barDisplay a contextual menu |
Shift + F10 |
Work in cells or the Formula barStart a formula |
= |
Work in cells or the Formula barToggle the formula reference style between absolute, relative, and mixed |
⌘ + T or F4 |
Work in cells or the Formula barInsert the AutoSum formula |
⌘ + Shift + T |
Work in cells or the Formula barEnter the date |
Ctrl + ; (semicolon) |
Work in cells or the Formula barEnter the time |
⌘ + ; (semicolon) |
Work in cells or the Formula barCopy 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 barAlternate between displaying cell values and displaying cell formulas |
Ctrl + ` (grave accent) |
Work in cells or the Formula barCopy a formula from the cell above the active cell into the cell or the formula bar |
Ctrl + ' (apostrophe)) |
Work in cells or the Formula barDisplay the AutoComplete list |
Ctrl + Option + Arrow Down |
Work in cells or the Formula barDefine a name |
Ctrl + L |
Work in cells or the Formula barOpen the Smart Lookup pane |
Ctrl + Option + ⌘ + L |
Format and edit dataEdit the selected cell |
F2 |
Format and edit dataCreate a table |
⌘ + T or Ctrl + T |
Format and edit dataInsert a line break in a cell |
⌘ + Option + Return or Ctrl + Option + Enter |
Format and edit dataInsert special characters like symbols, including emoji |
Ctrl + Spacebar or ⌘ + Space |
Format and edit dataIncrease font size |
⌘ + Shift + > |
Format and edit dataDecrease font size |
⌘ + Shift + < |
Format and edit dataAlign center |
⌘ + E |
Format and edit dataAlign left |
⌘ + L |
Format and edit dataDisplay the Modify Cell Style dialog box |
⌘ + Shift + L |
Format and edit dataDisplay the Format Cells dialog box |
⌘ + 1 |
Format and edit dataApply the general number format |
Ctrl + Shift + ~ |
Format and edit dataApply the currency format with two decimal places (negative numbers appear in red with parentheses) |
Ctrl + Shift + $ |
Format and edit dataApply the percentage format with no decimal places |
Ctrl + Shift + % |
Format and edit dataApply the exponential number format with two decimal places |
Ctrl + Shift + ^ |
Format and edit dataApply the date format with the day, month, and year |
Ctrl + Shift + # |
Format and edit dataApply the time format with the hour and minute, and indicate AM or PM |
Ctrl + Shift + @ |
Format and edit dataApply the number format with two decimal places, thousands separator, and minus sign (-) for negative values |
Ctrl + Shift + ! |
Format and edit dataApply the outline border around the selected cells |
⌘ + Option + 0 |
Format and edit dataAdd an outline border to the right of the selection |
⌘ + Option + Arrow Right |
Format and edit dataAdd an outline border to the left of the selection |
⌘ + Option + Arrow Left |
Format and edit dataAdd an outline border to the top of the selection |
⌘ + Option + Arrow Up |
Format and edit dataAdd an outline border to the bottom of the selection |
⌘ + Option + Arrow Down |
Format and edit dataRemove outline borders |
⌘ + Option + - (hyphen) |
Format and edit dataApply or remove bold formatting |
⌘ + B |
Format and edit dataApply or remove italic formatting |
⌘ + I |
Format and edit dataApply or remove underscoring |
⌘ + U |
Format and edit dataApply or remove strikethrough formatting |
⌘ + Shift + X |
Format and edit dataHide a column |
⌘ + ) or Ctrl + ) |
Format and edit dataUnhide a column |
⌘ + Shift + ) or Ctrl + Shift + ) |
Format and edit dataHide a row |
⌘ + ( or Ctrl + ( |
Format and edit dataUnhide a row |
⌘ + Shift + ( or Ctrl + Shift + ( |
Format and edit dataEdit the active cell |
Ctrl + U |
Format and edit dataCancel an entry in the cell or the formula bar |
Esc |
Format and edit dataEdit 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 dataPaste text into the active cell |
⌘ + V |
Format and edit dataComplete a cell entry |
Enter |
Format and edit dataGive selected cells the current cell's entry |
⌘ + Return or Ctrl + Enter |
Format and edit dataEnter a formula as an array formula |
⌘ + Shift + Return or Ctrl + Shift + Enter |
Format and edit dataDisplay the Formula Builder after you type a valid function name in a formula |
Ctrl + A |
Select cells, columns, or rowsExtend the selection by one cell |
Shift + Arrow Key |
Select cells, columns, or rowsExtend the selection to the last nonblank cell in the same column or row as the active cell |
⌘ + Shift + Arrow Key |
Select cells, columns, or rowsExtend the selection to the beginning of the row |
Shift + Home |
Select cells, columns, or rowsExtend the selection to the beginning of the sheet |
Ctrl + Shift + Home |
Select cells, columns, or rowsExtend the selection to the last cell used on the sheet (lower-right corner) |
Ctrl + Shift + End |
Select cells, columns, or rowsSelect the entire column |
Ctrl + Space |
Select cells, columns, or rowsSelect the entire row |
Shift + Space |
Select cells, columns, or rowsSelect the entire sheet |
⌘ + A |
Select cells, columns, or rowsSelect only visible cells |
⌘ + Shift + * (asterisk) |
Select cells, columns, or rowsSelect only the active cell when multiple cells are selected |
Shift + Delete |
Select cells, columns, or rowsExtend the selection down one screen |
Shift + Page Down |
Select cells, columns, or rowsExtend the selection up one screen |
Shift + Page Up |
Select cells, columns, or rowsAlternate between hiding objects, displaying objects, and displaying placeholders for objects |
Ctrl + 6 |
Select cells, columns, or rowsTurn on the capability to extend a selection by using the arrow keys |
F8 |
Select cells, columns, or rowsAdd another range of cells to the selection |
Shift + F8 |
Select cells, columns, or rowsSelect the current array, which is the array that the active cell belongs to. |
Ctrl + / |
Select cells, columns, or rowsSelect 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 rowsSelect only cells that are directly referred to by formulas in the selection |
Ctrl + Shift + [ |
Select cells, columns, or rowsSelect all cells that are directly or indirectly referred to by formulas in the selection |
Ctrl + Shift + { |
Select cells, columns, or rowsSelect only cells with formulas that refer directly to the active cell |
Ctrl + ] |
Select cells, columns, or rowsSelect all cells with formulas that refer directly or indirectly to the active cell |
Ctrl + Shift + } |
Work with a selectionCopy |
⌘ + C or Ctrl + C |
Work with a selectionPaste |
⌘ + V or Ctrl + V |
Work with a selectionCut |
⌘ + X or Ctrl + X |
Work with a selectionClear |
Delete |
Work with a selectionDelete the selection |
Ctrl + - (hyphen) |
Work with a selectionUndo the last action |
⌘ + Z |
Work with a selectionHide a column |
⌘ + ) or Ctrl + ) |
Work with a selectionUnhide a column |
⌘ + Shift + ) or Ctrl + Shift + ) |
Work with a selectionHide a row |
⌘ + ( or Ctrl + ( |
Work with a selectionUnhide a row |
⌘ + Shift + ( or Ctrl + Shift + ( |
Work with a selectionMove from top to bottom within the selection (down)* |
Enter |
Work with a selectionMove from bottom to top within the selection (up)* |
Shift + Enter |
Work with a selectionMove from left to right within the selection, or move down one cell if only one column is selected |
Tab |
Work with a selectionMove from right to left within the selection, or move down one cell if only one column is selected |
Shift + Tab |
Work with a selectionMove clockwise to the next corner of the selection |
Ctrl + . (period) |
Work with a selectionGroup selected cells |
⌘ + Shift + K |
Work with a selectionUngroup 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 chartsInsert a new chart sheet. |
F11 |
Use chartsCycle through chart object selection |
ArrowKeys |
Sort, filter, and use PivotTable reportsOpen the Sort dialog box |
⌘ + Shift + R |
Sort, filter, and use PivotTable reportsAdd or remove a filter |
⌘ + Shift + F or Ctrl + Shift + L |
Sort, filter, and use PivotTable reportsDisplay the Filter list or PivotTable page field pop-up menu for the selected cell |
Option + Arrow Down |
Outline dataDisplay or hide outline symbols |
Ctrl + 8 |
Outline dataHide selected rows |
Ctrl + 9 |
Outline dataUnhide selected rows |
Ctrl + Shift + ( (opening parenthesis) |
Outline dataHide selected columns |
Ctrl + 0 (zero) |
Outline dataUnhide 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 |