Forum Discussion
donwb1505
Dec 19, 2018Copper Contributor
365 toolbars / ribbon
I'm new to Office 365, migrating from Office 2003. In a particular Excel file I use macros and one of them generates a Custom Command Bar. I also have a custon Excel 2003 "menu-like" toolbar, whic...
Dec 19, 2018
Hi donwb1505,
You can’t modify the size of the ribbon itself (unless you modify the screen resolution) as per article
https://support.office.com/en-gb/article/Customize-the-ribbon-in-Office-00f24ca7-6021-48d3-9514-a31a460ecb31
However, there is a few options
You could just show the ribbon tabs where the ribbon only displays where you select a tab and then hides when you go back to the sheet.
https://support.office.com/en-us/article/Show-or-hide-the-ribbon-in-Office-d946b26e-0c8c-402d-a0f7-c6efa296b527#_showonly
Or, you could look to customise the commands in the tab which may shrink from two bars to one (may work)
https://support.office.com/en-gb/article/Customize-the-ribbon-in-Office-00f24ca7-6021-48d3-9514-
Would recommend the first option as it’s more likely to give you what you want and save the most space.
Let me know how you got on. I hope I have answered your question. If I have please like and set as the solution. If not, let me know what more you need.
Best, Chris
You can’t modify the size of the ribbon itself (unless you modify the screen resolution) as per article
https://support.office.com/en-gb/article/Customize-the-ribbon-in-Office-00f24ca7-6021-48d3-9514-a31a460ecb31
However, there is a few options
You could just show the ribbon tabs where the ribbon only displays where you select a tab and then hides when you go back to the sheet.
https://support.office.com/en-us/article/Show-or-hide-the-ribbon-in-Office-d946b26e-0c8c-402d-a0f7-c6efa296b527#_showonly
Or, you could look to customise the commands in the tab which may shrink from two bars to one (may work)
https://support.office.com/en-gb/article/Customize-the-ribbon-in-Office-00f24ca7-6021-48d3-9514-
Would recommend the first option as it’s more likely to give you what you want and save the most space.
Let me know how you got on. I hope I have answered your question. If I have please like and set as the solution. If not, let me know what more you need.
Best, Chris