CtrlShiftEnd: Extend the selection of cells to the last used cell on the worksheet (lower-right corner).

For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.

For example, on the Home tab, the Number group includes the Number Format option.

Press the Alt key to display the ribbon shortcuts, called Key Tips, as letters in small images next to the tabs and options as shown in the image below.

For example, press AltH to open the Home tab, and AltQ to move to the Tell me or Search field.

Press Alt again to see KeyTips for the options for the selected tab.

A notification pops up saying youre using an access key from an earlier version of Microsoft Office.

If you dont know the sequence, press Esc and use Key Tips instead.

Additional tabs may appear depending on your selection in the worksheet.

AltF: Open the File page and use Backstage view AltH: Open the Home tab and format text and numbers and use the Find tool.

AltN: Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.

AltP: Open the Page Layout tab and work with themes, page setup, scale, and alignment.

AltM: Open the Formulas tab and insert, trace, and customize functions and calculations.

AltA: Open the Data tab and connect to, sort, filter, analyze, and work with data.

AltR: Open the Review tab and check spelling, add notes and threaded comments, and protect sheets and workbooks.

Tab key or ShiftTab: Move the focus to commands on the ribbon.

Arrow keys: Move down, up, left, or right, respectively, among the items on the Ribbon.

Down arrow key: When a menu or submenu is open, move to the next command.

Left arrow key: Move to the sub menu when a main menu is open or selected.

CtrlArrow key: Move to the edge of the current data region in a worksheet.

End, Arrow key: Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode.

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

CtrlEnd: Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.

Excel Keytips For Mac