7th Oct 2019, 04:13 PM #1
My Excel Ribbon is too fat .....sometimes
I have a heavily customised ribbon in Excel, which I set up 3½ years ago with significant online help.
Of course I have forgotten how to do it now.....
When I have my spreadsheet a little narrower (about 2/3 screen width) the groups of icons on the right get squashed to drop downs,
when I have ribbon control set to "Show Tabs and Commands", which is by far my preference (I use a lot of buttons).
Look at all that useless real estate between the icons!
However, when I set the ribbon control to "Show Tabs" I get the ribbon displaying as I would like it to:
Now THET is more like it! All nice and squeezed up with all of my buttons visible, but the problem is it means an extra click to show the ribbon, and that also means quite significant cursor travel with my pen (mouse).
So the question of course how to get the ribbon displaying like the second pic, but permanently, without having to click to drop it down.
(I know I can add the most frequently used to the quick access toolbar, but you can see it's already full - and it can't be made into two lines .... dopey Microsoft......)
7th Oct 2019 04:13 PM # ADSGoogle Adsense Advertisement
- Join Date
- Advertising world
7th Oct 2019, 08:58 PM #2GOLD MEMBER
- Join Date
- Jun 2005
Set the ribbon to auto and use control + F1 to bring it up?CHRIS
7th Oct 2019, 09:09 PM #3
That's the infuriating thing Chris - when you set it to auto it goes full screen by default - all the wasted space is compressed (when it LEAST needs to be.......).
This is a big screen.....very rare to have any window full screen.
By powderpost in forum BANDSAWSReplies: 6Last Post: 1st May 2011, 02:21 PM
By RufflyRustic in forum WOOD WHISPERING WOMENReplies: 5Last Post: 24th Jan 2010, 05:27 AM
By dj_pnevans in forum CASTING & STABILISATIONReplies: 6Last Post: 11th Feb 2009, 10:01 PM
By Barry Hicks in forum WOODIES JOKESReplies: 0Last Post: 7th Dec 2007, 05:50 PM
By Metung in forum STRUCTURAL RENOVATION, ROOFING, DEMOLITION, etcReplies: 3Last Post: 18th Aug 2005, 06:41 PM