365 toolbars / ribbon

%3CLINGO-SUB%20id%3D%22lingo-sub-304431%22%20slang%3D%22en-US%22%3E365%20toolbars%20%2F%20ribbon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304431%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20new%20to%20Office%20365%2C%20migrating%20from%20Office%26nbsp%3B2003.%3C%2FP%3E%3CP%3EIn%20a%20particular%20Excel%20file%26nbsp%3BI%20use%20macros%26nbsp%3Band%20one%20of%26nbsp%3Bthem%20generates%20a%20Custom%20Command%20Bar.%3C%2FP%3E%3CP%3EI%20also%26nbsp%3Bhave%20a%20custon%20Excel%202003%26nbsp%3B%26nbsp%3B%22menu-like%22%20toolbar%2C%20which%20shows%20in%20all%20of%20my%202003%20Excel%20files.%3C%2FP%3E%3CP%3EIn%20365%2C%20under%20the%20%26nbsp%3BAdd-ins%20tab%2C%20both%20these%20appear%2C%26nbsp%3Bwhich%20is%20exactly%20what%20I%20want%20(though%20I%20don't%20know%20what%20makes%20the%20%3CSTRONG%3Ecustom%3C%2FSTRONG%3E%20tool%20bar%20appear%20in%20365%20-%20it's%20on%20a%20template%20in%202003)%3C%2FP%3E%3CP%3EHowever%20the%20problem%20is%20that%20they%20appear%20in%20a%20deep%20band%20at%20the%20top%20of%20the%20screen%20which%20is%20the%20same%20height%20as%20the%20standard%20ribbon.%3C%2FP%3E%3CP%3EThis%20is%20taking%20up%20some%2020%25%20of%20screen%20height%20when%20the%202%20bars%20need%20much%20less%20space.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20reduce%20the%20space%20occupancy%20to%20just%20enough%20for%20the%202%20bars.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304431%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304456%22%20slang%3D%22en-US%22%3ERe%3A%20365%20toolbars%20%2F%20ribbon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304456%22%20slang%3D%22en-US%22%3EHi%20donwb1505%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%E2%80%99t%20modify%20the%20size%20of%20the%20ribbon%20itself%20(unless%20you%20modify%20the%20screen%20resolution)%20as%20per%20article%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2FCustomize-the-ribbon-in-Office-00f24ca7-6021-48d3-9514-a31a460ecb31%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2FCustomize-the-ribbon-in-Office-00f24ca7-6021-48d3-9514-a31a460ecb31%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%20there%20is%20a%20few%20options%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20could%20just%20show%20the%20ribbon%20tabs%20where%20the%20ribbon%20only%20displays%20where%20you%20select%20a%20tab%20and%20then%20hides%20when%20you%20go%20back%20to%20the%20sheet.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FShow-or-hide-the-ribbon-in-Office-d946b26e-0c8c-402d-a0f7-c6efa296b527%23_showonly%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FShow-or-hide-the-ribbon-in-Office-d946b26e-0c8c-402d-a0f7-c6efa296b527%23_showonly%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOr%2C%20you%20could%20look%20to%20customise%20the%20commands%20in%20the%20tab%20which%20may%20shrink%20from%20two%20bars%20to%20one%20(may%20work)%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2FCustomize-the-ribbon-in-Office-00f24ca7-6021-48d3-9514-%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2FCustomize-the-ribbon-in-Office-00f24ca7-6021-48d3-9514-%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWould%20recommend%20the%20first%20option%20as%20it%E2%80%99s%20more%20likely%20to%20give%20you%20what%20you%20want%20and%20save%20the%20most%20space.%3CBR%20%2F%3E%3CBR%20%2F%3ELet%20me%20know%20how%20you%20got%20on.%20I%20hope%20I%20have%20answered%20your%20question.%20If%20I%20have%20please%20like%20and%20set%20as%20the%20solution.%20If%20not%2C%20let%20me%20know%20what%20more%20you%20need.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E
Highlighted
Frequent Visitor

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, which shows in all of my 2003 Excel files.

In 365, under the  Add-ins tab, both these appear, which is exactly what I want (though I don't know what makes the custom tool bar appear in 365 - it's on a template in 2003)

However the problem is that they appear in a deep band at the top of the screen which is the same height as the standard ribbon.

This is taking up some 20% of screen height when the 2 bars need much less space.

Is there a way to reduce the space occupancy to just enough for the 2 bars.

1 Reply
Highlighted
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-a31a...

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-c...

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