excel 2016 keyboard shortcuts and function keys for mac

Pressing CtrlShiftSpacebar a third time selects the entire worksheet.When an object is selected, CtrlShiftSpacebar selects all objects on a worksheet.

Open the Tell me box on the Ribbon and type a search term for assistance or Help content.

If the cells are blank, move to the last cell in the row or column.

Or, if editing is turned off for the cell, move the insertion point into the formula bar.

If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference.

F8 Turn extend mode on and use the arrow keys to extend a selection.

Press a second time to select the current region and its summary rows.

In a worksheet that has been split, F6 includes the split panes when switching between panes and the ribbon area.

Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel.

In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.

When a submenu is open or selected, these arrow keys switch between the main menu and the submenu.

When a ribbon tab is selected, these keys navigate up or down the tab group.In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options.

In End mode, you can press an arrow key to move to the next nonblank cell in the same column or row as the active cell.

End mode turns off automatically after pressing the arrow key.

Make sure to press End again before pressing the next arrow key.

End mode is shown in the status bar when it is on.If the cells are blank, pressing End followed by an arrow key moves to the last cell in the row or column.End also selects the last command on the menu when a menu or submenu is visible.

If the cursor is in the formula bar, CtrlEnd moves the cursor to the end of the text.

If the cursor is in the formula bar, CtrlShiftEnd selects all text in the formula bar from the cursor position to the endthis does not affect the height of the formula bar.

Pressing CtrlShiftSpacebar a second time selects the current region and its summary rows.

Excel 2016 Keyboard Shortcuts And Function Keys For Mac