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.
-

Office 2024 Pro Plus key
$20.00 AUD
$39.00 -

Windows 11 Pro key
$14.99 AUD
$29.00 -

Windows 11 Home key
$18.88 AUD
$37.00
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
- Select Home or Insert to reveal that tab's commands temporarily.
- In Excel for Windows, press Ctrl+F1 to expand or collapse the command area.
- 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
- 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.
- 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.
- Right-click the ribbon and select Customize the Ribbon.
- In the list on the right, select the tab where you want your tools to appear.
- Select New Group, then Rename to give the group a useful name.
- Select a command from the list on the left and choose Add to place it in your custom group.
- 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.
Find related help across Office
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.
-

Windows 10 Pro key
$12.00 AUD
$15.00 -

Microsoft 365 Pro Plus, 5 devices
$15.00 AUD
$29.00 -

Windows Server 2022 Standard
$120.00 AUD
$239.00
How to check this worked
- Open Settings, System, Activation and confirm the edition shown.
- Enter the key and run activation; expect a green tick within a minute.
- 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).