How to reduce ribbon size in Excel

Excel 2016
After recent updates, the ribbon in Microsoft Excel can take up to 1/3 of the available screen space. Microsoft Office help tells that you can hide or unhide your ribbon, but you cannot reduce the size of your ribbon or the size of the text or the icons. False! You can change the mode, remove unnecessary white space around buttons and, thus, reduce the ribbon size.

The Ribbon display in Touch Mode:

The Ribbon display in Touch Mode in Excel 365

The Ribbon display in Mouse Mode (the habitual look of the previous versions of Microsoft Excel):

The Ribbon display in Mouse Mode in Excel 365

To change the Ribbon mode, click on the dropdown arrow on the right side of the Quick Access Toolbar and choose the Touch/Mouse Mode command:

Touch/Mouse Mode command in Excel 365

The Touch/Mouse Mode button was added to your Quick Access Toolbar menu (see more Adding commands to the Quick Access Toolbar):

Touch/Mouse Mode command in Excel 365

By choosing a specific option, you can change the Ribbon mode according to your needs.

Note: This option works for all Microsoft Office applications at once. If you change the mode in Excel, it changes in Microsoft Word, PowerPoint, and Outlook.

See also this tip in French: Comment réduire la taille du ruban dans Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

How to customize your local Excel

How to customize your local Excel

Excel is heavily used by all Microsoft Office users, and automatically opened workbooks, customizations of the menu, recent documents, and start screen allow you to save a lot of time.
How to view currency exchange rates in Excel

How to view currency exchange rates in Excel

When working with different currencies in an Excel spreadsheet, it is often necessary to use or compare exchange rates. Excel for Microsoft 365 offers a new Currencies Data Type. Like the Stock Data Type, the Currencies Data Type lets you get up-to-date exchange rates worldwide. It returns various exchange details that can be included in a spreadsheet.
How to view geography information in Excel

How to view geography information in Excel

Excel for Microsoft 365 offers a useful feature for using statistical information about geographic regions. Unfortunately, not all the information provided is up to date, such as population figures or tax rates. However, some data, such as region codes, is useful. You can easily use this information in an Excel spreadsheet: