Excel Ribbon Keyboard Shortcuts: A Practical Guide

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Alt to display KeyTips: small letters or letter combinations that tell you which keys open ribbon tabs and commands. Press the displayed keys in sequence to reach a command without the mouse—for example, Alt, H opens the Home tab, and Alt, H, H opens the Fill Color menu in the English-language desktop version.

What Excel ribbon shortcuts do

Ribbon shortcuts, also called KeyTips or access keys, are keyboard instructions for navigating the ribbon: the row of tabs and command groups above the worksheet. They are different from familiar worksheet shortcuts such as Ctrl+C and Ctrl+V. A ribbon shortcut takes you to a command such as Sort, Page Setup, or number formatting; a worksheet shortcut typically acts directly on selected cells or data.

KeyTips are useful when you want to keep your hands on the keyboard, when precise mouse targeting is difficult, or when you want to discover a command’s keyboard route. They are also a practical alternative to memorizing a long list of fixed shortcut combinations. Excel displays the next available KeyTips as you go, so you can follow the letters shown on your own screen.

This guide focuses on Excel for Microsoft 365 on Windows with the English interface. KeyTips can differ with language, ribbon customization, and Excel version. Treat the letters displayed by Excel as authoritative if they do not match an example here.

Open the main ribbon tabs with Alt

Press Alt once, then look at the ribbon. Excel puts KeyTips over tabs and other available commands. In the standard English Windows ribbon, common tab keys include:

  • Alt, H — Home, for formatting, alignment, and editing commands.
  • Alt, N — Insert, for tables, charts, pictures, and other inserted content.
  • Alt, P — Page Layout, for themes, scaling, and print layout settings.
  • Alt, M — Formulas, for function and calculation tools.
  • Alt, A — Data, for sorting, filtering, and data tools.
  • Alt, R — Review, for comments, notes, and proofing tools.
  • Alt, W — View, for worksheet views, window options, and zoom controls.
  • Alt, F — File, which opens the Backstage area for opening, saving, printing, and account-related options.

These are starting points, not a complete shortcut list. Once you open a tab, Excel displays another set of KeyTips for the commands on that tab. For example, after Alt, H, press the KeyTip shown above the relevant command or group. You do not need to hold Alt while typing the whole sequence; press and release the keys in order.

Follow KeyTips to a command

A typical ribbon action has three stages: show the KeyTips, open a tab, and choose the command. If you want to change a cell’s fill color, select the cell or range, press Alt, H, and then H to open the Fill Color menu. Use the arrow keys to move among the available colors and press Enter to select one. Press Esc if you opened the menu by mistake or want to back out.

Some commands open menus, while others act immediately or display a dialog box. After activating a command, read the screen: a dialog may have its own keyboard controls, and a menu may accept arrow keys, letter keys, or Enter. The sequence is not always a single fixed shortcut for every task. KeyTips can change as focus moves or as the ribbon changes, so watch the labels rather than guessing the next letter.

To find a command whose location you do not know, press Alt+Q to focus the Search box, sometimes labeled Tell Me, and type a command name such as “freeze panes” or “conditional formatting.” Choose the matching result from the suggestions. Search is not the same as navigating every ribbon group, but it can be faster when you know what an action is called and are unsure which tab contains it.

Move around the ribbon and its menus

After opening a tab with its KeyTip, use the KeyTips displayed for its controls. In many ribbon menus and dialogs, the arrow keys move between choices, Enter activates a choice, and Esc closes the current menu or backs out of a sequence. Tab and Shift+Tab move focus between many controls. Exact behavior depends on the control: a split button, gallery, dialog, or text box may respond differently.

If you lose track of where keyboard focus is, press Esc once to cancel or close the current menu, then press Alt again to start a fresh KeyTip sequence. Avoid pressing random letters in an open menu; a letter may select an item or enter text into a focused field. The visible focus indicator and KeyTips help show whether you are navigating the ribbon, a menu, or the worksheet.

Press Ctrl+F1 to show or hide the ribbon on Windows. This changes how much screen space the ribbon occupies; it does not turn off KeyTips. When the ribbon is collapsed, pressing a tab’s KeyTip can temporarily open that tab so you can use its commands. Press Esc to dismiss a temporarily displayed ribbon when appropriate.

Ribbon KeyTips versus ordinary Excel shortcuts

Not every keyboard action is a ribbon shortcut. Ctrl+B, for instance, applies or removes bold formatting directly; using Alt to reach the Home tab and select Bold is a ribbon route to a similar action. Ctrl+Z undoes the last eligible action, while Alt-based KeyTips navigate commands. Learning both types is useful, but they serve different purposes.

Use a direct shortcut when you know it and repeat an action often. Use KeyTips when you need a less familiar command, want to inspect ribbon options, or prefer a keyboard route that follows the visible interface. For example, Ctrl+1 opens Format Cells directly, while KeyTips can help you locate a less frequently used option in a tab or group. Excel also has shortcuts for moving around worksheets and selecting cells; those do not necessarily involve the ribbon at all.

A common misconception is that pressing Alt plus a tab letter performs the command shown on that tab. Usually it only opens the tab. Excel then displays additional KeyTips, and you must enter the next letter or letters to reach a particular command. The screen’s labels are the map for each step.

Contextual tabs and customized ribbons

Some ribbon tabs appear only when you select a particular object. Selecting a chart, for example, can show chart-specific tabs; selecting a table or picture can reveal its own contextual tools. Press Alt while that object is selected and use the KeyTips that appear for the tabs currently available. If the object is no longer selected, its contextual tab may disappear.

People can also customize the ribbon by adding, removing, or rearranging tabs and groups. That can change the layout and the KeyTips shown for commands. KeyTips are designed to guide you through the interface that is currently present, so a sequence learned on one customized installation may not be dependable on another. If you use more than one computer, check the displayed letters rather than assuming every route is identical.

In shared workbooks or instructions, it is often clearer to describe both the ribbon path and the keyboard method. For instance, “Home > Fill Color” identifies the command visually, while “Alt, H, H” gives a common English Windows route. The ribbon path remains helpful if KeyTips differ because of language or customization.

Differences on Mac and Excel for the web

The Alt-based KeyTip system described above applies to Excel for Windows. Excel for Mac does not provide the same one-to-one set of Windows Alt sequences, and Mac keyboard navigation can depend on macOS settings and the keyboard. On a Mac, use the command’s ribbon tab or Excel menu, consult Excel’s shortcut list, or enable keyboard access to controls in macOS settings. Do not assume a Windows sequence such as Alt, H, H will work unchanged on a Mac.

Excel for the web runs in a browser and supports many keyboard shortcuts, but browser commands and operating-system behavior can affect some key combinations. Ribbon controls and available features can also differ from the desktop application. If a shortcut is intercepted by the browser or a command is missing, use the web app’s visible ribbon or search, or open the workbook in desktop Excel when the task requires a desktop-only control.

Common problems and practical fixes

  • Alt does not show KeyTips: Confirm that Excel is the active window and not a dialog or another application. Click the workbook once, press Esc to leave an active edit or menu if needed, and try Alt again.
  • The letters look different: Follow the letters currently displayed. The interface language, customization, or version can alter a sequence.
  • A key types into a cell: Excel may still be editing a cell, or focus may be in a text field. Press Esc to cancel editing when appropriate, click the worksheet, and restart the sequence.
  • A command is unavailable: Some commands require a relevant selection, such as a chart or table. Select the object or range first, then inspect the ribbon again.
  • The sequence stopped working midway: Press Esc to clear the current menu or KeyTip level, then start again with Alt. Use the displayed next-step labels instead of relying on memory.

For a reliable routine, first select the correct cell, range, or object; then press Alt and read the labels; enter one displayed KeyTip at a time; and check the result before continuing. This reduces accidental changes, especially when commands open a menu or apply formatting immediately.

Frequently Asked Questions

What key opens the Excel ribbon shortcuts?
In Excel for Microsoft 365 on Windows, press Alt. KeyTips appear on the ribbon and show which keys to press next. The letters shown can vary with interface language and customization.

How do I get to the Home tab without a mouse?
Press Alt, then H in the standard English Windows interface. Excel opens Home and displays KeyTips for its commands. Follow the new labels to reach the control you need.

Can I use ribbon shortcuts on a Mac?
Windows Alt KeyTips do not map directly to Excel for Mac. Use Mac keyboard navigation and the command menus or ribbon; available navigation depends in part on macOS keyboard-access settings.

How do I search for a ribbon command?
On Windows, press Alt+Q, type the command’s name in Search, and choose the appropriate result. This is useful when you know what you want to do but do not know which tab contains it.

How do I close a ribbon menu or restart a shortcut sequence?
Press Esc to close a menu or move back from a KeyTip level. If necessary, press Esc again, then press Alt to begin a new sequence and follow the labels displayed on screen.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.