Topics Map > Office 365 > Excel

Microsoft Excel - Ribbon Shortcuts

Overview of Excel ribbon shortcuts

The ribbon groups related options on tabs. 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.

Image of Excel ribbon

You can combine the Key Tips letters with the Alt key to make shortcuts called Access Keys for the ribbon options. For example, press Alt+H to open the Home tab, and Alt+Q to move to the Tell me or Search field.


Use the Access keys for ribbon tabs

To go directly to a tab on the ribbon, press one of the following access keys. Additional tabs might appear depending on your selection in the worksheet.

Access keys

To do this

Pre

Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content.

Alt+Q, then enter the search term.

Open the File menu.

Alt+F

Open the Home tab and format text and numbers and use the Find tool.

Alt+

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

Alt+N

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

Alt+P

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

Alt+M

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

Alt+A

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

Alt+R

Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros.


Work in the ribbon with the keyboard

Work in the ribbon with the keyboard

To do this

Press

Select the active tab on the ribbon and activate the access keys.

Alt or F10. To move to a different tab, use access keys or the arrow keys.

Move the focus to commands on the ribbon.

Tab key or Shift+Tab

Move down, up, left, or right, respectively, among the items on the ribbon.

Arrow keys

Show the tooltip for the ribbon element currently in focus.

Ctrl+Shift+F10

Activate a selected button.

Spacebar or Enter

Open the list for a selected command.

Down arrow key

Open the menu for a selected button.

Alt+Down arrow key

When a menu or submenu is open, move to the next command.

Down arrow key

Expand or collapse the ribbon.

Ctrl+F1

Open a context menu.

Shift+F10

Or, on a Windows keyboard, the Windows Menu key (usually between the Alt Gr and right Ctrl keys)

Move to the submenu when a main menu is open or selected.

Left arrow key

Move from one group of controls to another.

Ctrl+Left or Right arrow key




Keywords:Microsoft Excel Ribbon Shortcuts Office 365   Doc ID:119441
Owner:Linda W.Group:UW Parkside
Created:2022-07-06 12:13 CDTUpdated:2022-07-06 12:27 CDT
Sites:UW Parkside
Feedback:  0   0