How to turn on or off Mini Toolbar

Excel 365
Excel displays a popup menu when you right-click the cell or the selected range. In addition, the Mini toolbar appears above or below the popup menu. The Mini toolbar in Excel contains commonly used tools from the Home tab. The Mini toolbar is especially useful when a tab other than Home is displayed.

However, you can turn it off if you don't use those tools often or always have the Home tab active:

Mini toolbar in Excel 365

To turn off the Mini Toolbar, follow the next steps:

   1.   On the File tab, click the Options button:

Excel 365 Options

   2.   In the Excel Options dialog box, on the General tab, check or uncheck the Show Mini Toolbar on selection checkbox:

Show Mini Toolbar on selection in Excel 365

   3.   Click OK.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more