Move between unlocked cells on a protected sheet

`Tab`

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