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.

Select the active tab of the ribbon, and activate the access keys.

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.

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 ribbon tab is selected, these keys navigate the tab buttons.

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.

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 For Mac Shortcut Zoom