How to Find Excel Tool Bar in Excel 2010

In this topic we will learn about how wecan hide toolbars in Excel 2010.

You can Hide Ribbon, Show Tabs and Show tabs with Commands from the bottom top icon of the spreadsheet through the Ribbon Display Option. In Excel this option is available in the top right corner.

 

img1

 

img2

 

  • When youclick on Auto-hide Ribbon, then tabs and commands will disappear from the spreadsheet. When you are working on the sheet, the ribbon will be hidden.

 

img3

 

To display the hidden ribbon click on the Ribbon Display Options button again and select Show tabs. This will display only the main tabs. If you want the commands in the tab to be visible, you need to click on the specific tab.

 

img4

 

img5

 

  • To display all the tabs and its commands click on the Ribbon Display Options button and then
    select Show tabs and Commands.

 

img6

 

img7

 

There is another way to show and hide the commands, just double click on the main tab from the ribbon.

 

img8

 

The above is the menu which appears when you open the excel file.

 

img10

 

So now double click on the “Home” tab as an example and you will that the commands in each tab will disappear.

 

img11

 

Now if you double click on the “Home” tab again, you will be able to see the menu commands.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.