The content area in the Excel workbook is generally small. The ribbon area occupies the top portion of excel containing tool icons and text descriptions for each menu tabs. When you have a larger excel sheets, you should get rid of the ribbon area to get convenient space. It also makes sense to show or hide that ribbon when you needed. In this article let us discuss how to show or hide ribbon in Excel on Windows and MacBook. ![]() ![]() Though we have explained with Excel, all these tricks will work on all Microsoft Office applications like Excel, Word and PowerPoint. Related: Show or Hide Ribbon in Windows 1. Use Arrow Button The easiest way is to click the small up arrow shown at the right end of the ribbon. This will hide the ribbon showing all the menu items, thus allowing to have some visible area for cells. No Collapse Ribbon Option Here comes the use of handy. Simply press “Ctrl + F1” keys to toggle the ribbon on or off. This means you can hide and show the ribbon by pressing these shortcut keys. We recommend to use this shortcut keys instead of using the arrow or right click to hide ribbon. This should also work on Word, PowerPoint and all Microsoft applications. Auto Hide Ribbon You can also automatically hide the ribbon and show only when you click on the top bar. Click on the arrow button showing next to minimize icon. Choose “Auto-hide Ribbon” option. Show Ribbon Again For permanently enabling it back, click on the arrow button again and choose either “Show Tabs” or “Show Tabs and Commands” option. Pin the Ribbon The last option is to pin your ribbon. Follow the below steps to pin the ribbon on excel: • Press “Control + F1” to hide the ribbon first. Battle royale game download. • Click on any of the menu items to view the ribbon again. • Now you will see a small pin icon at the lower right corner of the ribbon. Review Tab in Microsoft Excel Review tab contains the editing feature, comments, track changes and workbook protection options. These features make it easy to share the data with the proper information whilst ensuring security of data. • Click on it and the ribbon. This will ensure the ribbon is always there when you work on that spreadsheet. Customize Ribbon in Excel There are two drop-downs in the right pane, “Choose commands from” and “Customize the Ribbon”. Choose the required items and move to the needed tabs. Ntfs for mac. You can also enable, disable, reorder and regroup the tabs. If something goes wrong click “Reset all customizations” from the “Customizations” dropdown to set the ribbon back to initial settings. Related: Control Ribbon Appearance on Excel Mac Similar to Windows, you can use shortcuts and customize the ribbon appearance in Mac also. Toggle Ribbon in Excel Mac with Shortcut Keys Simply press ‘Command + Option + R’ to toggle the ribbon on Excel. This means ribbon will show when you press the shortcut keys first time and then will be hidden if you press second time. Use Arrow to Hide or Show Ribbon Another easiest way in Mac is to click on the arrow nearer to right corner.
0 Comments
Leave a Reply. |