How To use Excel : How to Minimize Ribbon in Excel

Share with friends

Introduction

In our previous tutorial we explored the most powerful part of an Excel worksheet - the mighty ribbon. We have also familiarised ourselves with the different sections and commands that are available on the ribbon. Most of the time users prefer to keep the ribbon visible all the time while working with Excel but sometimes we may need to hide the ribbon so that the main working area of the excel sheet increases. In this tutorial we'll see how to minimize the excel ribbon.

Different Methods to Minimize Ribbon in Excel

Below are the different ways in which we can minimize ribbon in Excel.

Method 1 :

Click the ‘Collapse the Ribbon Button’.

Method 2 :

Double click a ribbon tab.

Method 3 :

Press Ctrl + F1

Method 4 :

Step 1 : Click on Ribbon Display Options button.

Step 2 : Click on ‘Show Tabs’ item

Different Methods to redisplay a Minimized Ribbon in Excel

Below are the different ways of redisplaying a ribbon that was previously minimized.

Method 1 :

Step 1 : Click any tab on the Ribbon.

Step 2 : Click on the “Pin the Ribbon” button.

Method 2 :

Double click a ribbon tab.

Method 3 :

Press Ctrl + F1

Method 4 :

Step 1 : Click on Ribbon Display Options button.

Step 2 : Click on ‘Show Tabs and Commands’ item

Conclusion :

Though most of the users will always keep the ribbon visible to them but if you are preparing some report or working on any other complicated worksheet then you might want to hide the ribbon to increase the worksheet area. In this case the methods given above will be very useful.