The Mini Toolbar is a small floating set of formatting controls that puts tools close to your selection. It gives you a way to make a formatting change without returning to a Ribbon tab. In its Windows Office documentation, Microsoft describes it as appearing when you select text and enable Show Mini Toolbar on selection.
I frequently use bold and centered text for my table headings. Small formatting jobs like that are why having controls close to the work can be useful. The Mini Toolbar, the Ribbon, and the Quick Access Toolbar all offer access to commands, but they serve different purposes.
Show or hide the Mini Toolbar on selection in Windows
In desktop Excel for Windows:
- Open File > Options > General.
- Under User Interface options, find Show Mini Toolbar on selection.
- Select the checkbox to enable it, or clear it to stop the toolbar appearing on text selection.
- Click OK.
Microsoft's General options documentation lists Excel for Microsoft 365, Excel 2024, 2021, 2019, and 2016. It also notes that the available options vary by program and version.
The wording matters: this setting describes text selection. It does not establish whether clearing the checkbox also removes a toolbar shown with a right-click menu. Don't treat it as a documented switch for every right-click formatting control.
Mini Toolbar vs Ribbon vs Quick Access Toolbar
| Feature | What it does | When it helps |
|---|---|---|
| Mini Toolbar | Offers formatting controls close to a selection. | You want a nearby formatting command. |
| Ribbon | Organizes commands into tabs such as Home and Insert. | You need to browse the commands for a task. |
| Quick Access Toolbar (QAT) | Holds a customizable set of commands independent of the active Ribbon tab. | You want particular commands available while you switch tabs. |
For example, adding Freeze Panes to the Quick Access Toolbar gives that command a regular place to live. Microsoft's QAT guide also explains how to show the toolbar and move it above or below the Ribbon in Windows.
The Ribbon has its own display options, including showing tabs only or keeping commands visible. If you're following an older tutorial, our historical Home tab comparison for Excel 2010 on Windows and Excel 2011 on Mac helps identify those older layouts; it isn't a guide to today's interface.
If you don't see the Mini Toolbar
In Windows, check the selection setting above. Clicking a cell and selecting text are different actions; the cited setting describes the latter. If the command you need isn't beside your selection, return to the appropriate Ribbon tab.
The Windows instructions above don't establish how the Mini Toolbar works in current Excel for Mac or Excel for the web. Availability and an equivalent setting on those platforms remain unverified here.