In this article, we will learn How to Minimize the Excel Ribbon
Scenario:
Show collapsed ribbon in full view
If the Excel ribbon is minimized so that only tab names are visible, do one of the following to get it back to a normal full display:
Unhide ribbon in Excel
If the ribbon is hidden completely including the tab names, here's how you can restore it:
Similar methods can be used to hide ribbon in Excel, and the next section explains the details.
If the ribbon takes up too much space at the top of your worksheet, especially on a small screen laptop, you can collapse it to show only the tab names or hide the ribbon altogether.
Minimize the ribbon
To see only the tab names without commands like in the screenshot below, use any of the following techniques:
Hide ribbon completely
If you aim to have the largest amount of screen space for a workbook area, use the Auto-hide option to get Excel in kind of full screen mode:
Click the Ribbon Display Options icon on the top-right corner of the Excel window, to the left of the Minimize icon.
Click Auto-hide Ribbon.
This will totally hide the ribbon, including all tabs and commands.
If all of a sudden the ribbon disappears from your Excel, it's most likely to be one of the following cases.
Tabs show up but commands disappeared
Perhaps you have inadvertently hidden the ribbon with an errant keystroke or mouse click. To show all the commands again, click Ctrl + F1 or double-click any ribbon tab.
Whole ribbon missing
Most probably your Excel somehow got into a "full screen" mode. To restore the ribbon, click the Ribbon Display Options button at the top-right corner, and then click Show Tabs and Commands. This will lock the ribbon at the top of the Excel window where it belongs. For the detailed instructions, please see How to unhide ribbon in Excel.
Contextual tabs disappeared
If the Tool Tabs specific to a particular object (such as a chart, image, or PivotTable) are missing, that object has lost focus. For the contextual tabs to appear again, simply select the object.
Add-ins tab missing
You've been using some Excel add-in (e.g. our Ultimate Suite) for a while, and now the add-in's ribbon is gone. Chances are the add-in was disabled by Excel.
To fix this, click File > Excel Options > Add-ins > Disabled Items > Go. If the add-in is in the list, select it and click the Enable button
Note:
Hope this article about How to Minimize the Excel Ribbon & Its use is explanatory. Find more articles on calculating values and related Excel formulas here. If you liked our blogs, share them with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write to us at info@exceltip.com.
Useful Articles :
10+ Creative Advanced Excel Charts to Rock Your Dashboard : These creative charts can make you stand apart from the crowd. These charts can be used for different types of reports. Your dashboard will be more expressive than ever.
How to Save and Use an Excel Chart Template : It is important to save chart templates for repetitive charts to save time and energy. To save chart templates in excel follow these steps.
Best Charts in Excel and How To Use Them : These are some of the best charts that Excel provides. You should know how to use these charts and how they are interpreted. The line, column and pie chart are some common and but effective charts that have been used since the inception of the charts in excel. But Excel has more charts to explore.
Excel Sparklines : The Tiny Charts in Cell : These small charts reside in the cells of Excel. They are new to excel and not much explored. There are three types of Excel Sparkline charts in Excel. These 3 have sub categories, let's explore them.
Change Chart Data as Per Selected Cell : To change data as we select different cells we use worksheet events of Excel VBA. We change the data source of the chart as we change the selection or the cell. Here's how you do it.
Popular Articles :
50 Excel Shortcuts to Increase Your Productivity : Get faster at your tasks in Excel. These shortcuts will help you increase your work efficiency in Excel.
How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup a value from different ranges and sheets.
How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE.
How to use the SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.
How to use the COUNTIF Function in Excel : Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.
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.
