Microsoft Office

Where Is The Ribbon In Microsoft Excel

The ribbon in Microsoft Excel is at the top of the workbook window, below the title bar and above the formula bar and worksheet. Look for tabs such as Home, Insert, Formulas and Data. Select a tab to see its commands. If only the tab.

Which licences fit your PC setup?

Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.

How to recognise the ribbon

The ribbon has two main parts: a row of tabs and the command area beneath them. Each tab brings together tools for a type of work. Within a tab, related commands are organised into groups. On Home, for example, the Font group contains controls for text appearance, while the Number group controls how values are displayed.

The ribbon is separate from the formula bar, where you can view or edit the contents of the selected cell. It is also separate from the worksheet tabs along the bottom of the workbook, which switch between sheets.

Selecting File opens options for working with the workbook itself, such as opening, saving and printing. Select Home or another ribbon tab to return to worksheet commands.

Show the ribbon when it is hidden

A missing command area usually means the ribbon has been collapsed or its display setting has changed. Start by checking whether you can still see the tab names.

If the tabs are visible but the commands are missing

  1. Select Home or Insert to reveal that tab's commands temporarily.
  2. In Excel for Windows, press Ctrl+F1 to expand or collapse the command area.
  3. To keep the commands visible, open Ribbon Display Options and select Always show ribbon. Some interfaces label this option Show Tabs and Commands.

The position and wording of the display controls vary between interfaces. Look near the ribbon's right edge or the upper-right area of the Excel window. Microsoft's guide to showing the Excel ribbon illustrates the available display options.

If the tabs are hidden too

  1. In the Windows desktop app, select the ellipsis (...) at the upper right, if shown, or press Alt to reveal the ribbon in full-screen mode.
  2. Open Ribbon Display Options and select Always show Ribbon.

Microsoft's Office ribbon display guide shows this full-screen setting. Excel for Mac and Excel in a browser may present different controls.

If you deliberately want more room for your worksheet, double-click a ribbon tab in the Windows desktop app to collapse the commands. Double-click it again when you want them to stay open.

Choose the right tab for your task

You do not need to learn every command at once. Use the task you want to complete to choose a starting tab.

Task Tab to open Examples of tools
Format or edit cells Home Font size, fill colour, alignment, number formats and conditional formatting
Add a table or chart Insert Tables, PivotTables, charts, pictures and shapes
Prepare a sheet for printing Page Layout Margins, orientation, print area and scaling
Work with calculations Formulas Function Library, defined names and formula auditing
Organise or clean data Data Sort, Filter, Remove Duplicates and data validation
Review or protect a worksheet Review Spelling and protection commands
Change the worksheet view View Zoom, gridlines and Freeze Panes

Some tools appear in more than one place. Sorting and filtering, for example, are available through Home as well as Data. Creating a PivotTable starts on Insert, even though its purpose is data analysis.

Use the selection to reveal more tools

Additional tabs can appear when you select an object. Selecting a chart reveals chart-specific tools; selecting a cell inside an Excel table reveals table tools. Click back into an ordinary worksheet cell and those contextual tabs may disappear.

If a command is greyed out, check what you have selected and whether the worksheet is protected. If buttons appear condensed into menus, maximise the window to give the ribbon more space.

Customise the ribbon in Excel for Windows

If you repeatedly use the same commands, you can collect them in a custom group. Start with a small group so that it remains easy to scan.

  1. Right-click the ribbon and select Customize the Ribbon.
  2. In the list on the right, select the tab where you want your tools to appear.
  3. Select New Group, then Rename to give the group a useful name.
  4. Select a command from the list on the left and choose Add to place it in your custom group.
  5. Repeat for the other commands you need. Use the up and down arrows to adjust their order, then select OK.

You can also create a New Tab or use the checkboxes to show or hide available tabs. Commands you add must go into custom groups: you cannot directly remove individual commands from built-in groups. Microsoft's ribbon customisation instructions explain these limits.

The Microsoft Office guides cover related tasks in Excel and Word. If you are exploring the font controls on Home, the explanation of how fonts are measured in Microsoft Word provides background on point sizes. For setting up Word on a separate Windows 10 computer, see the guide to free Microsoft Word download options for Windows 10.

Open a workbook, select Home and locate the Font and Number groups. If they disappear when you return to the worksheet, change the ribbon display setting to keep the commands visible.

Other editions for separate workloads

Other editions for separate workloads; prices in AUD, confirm the total on the listing.

How to check this worked

  1. Open Settings, System, Activation and confirm the edition shown.
  2. Enter the key and run activation; expect a green tick within a minute.
  3. Reboot and re-check activation survives the restart.

FAQ

What else should you know before buying?

What do I need before starting?
Read the requirements and confirm the edition first; the steps assume the machine is compatible.
How do I know the licence is genuine?
Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
Is this a subscription?
Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
What if the key fails?
Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.

Check who prepared and reviewed this guide

Written by
MS.Codes editorial
Reviewed by
Support team

Last verified: (source review; see test status above).

Recent Post