How To Show and Hide Mini Tool Bar in Excel


Introduction :

Excel has always tried make its users' life easier as much as possible. It has loads of such features that will allow users to perform complex tasks in much easier manner. Mini toolbar is one such feature. It is the small toolbar that appears when we right click on any cell in the worksheet. Though this mini toolbar is of great help to the users as it conatains some very frequently used commands and users can directly use these commands just by right clicking on the cell. But sometimes some users do not prefer seeing this toolbar everytime. Scenarios may arise where users are working on some complex spreadsheet and they not want to use the commands on the mini toolbar when they right click on the cells. In this case users can easily hide the Mini toolbar. In this tutorial we'll learn how to do this.

Show/Hide Mini Toolbar

Below are the steps to show or hide mini toolbar in Excel.

Step 1 :

Click on the “File” command button in the top left corner of the worksheet.

Show and Hide Mini Tool Bar in Excel
Step 2 :

The backstage view of Excel will be displayed. Locate the “Options” command at the bottom of the left side pane.

Show and Hide Mini Tool Bar in Excel
Step 3 :

Click on the “Options” command.

Show and Hide Mini Tool Bar in Excel
Step 4 :

The Excel Options dialog box is displayed. Locate the option “Show Mini Toolbar on Selection” in the right side pane of the dialog box.

Show and Hide Mini Tool Bar in Excel
Step 5 :

Check this checkbox to show the mini tool bar and uncheck the checkbox to hide the mini toolbar.

Show and Hide Mini Tool Bar in Excel

Conclusion :

Hiding and showing features like Mini toolbar is a matter of preference and the type of data and spreadsheet we are working on. But it is always useful that we know how to hide and then show such features.