Thanks: 0
Likes: 0
Needs Pictures: 0
Picture(s) thanks: 0
Results 1 to 11 of 11
-
7th October 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).
fat ribbon.jpg
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:
Thin Ribbon.jpg
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 October 2019 04:13 PM # ADSGoogle Adsense Advertisement
- Join Date
- Always
- Location
- Advertising world
- Posts
- Many
-
7th October 2019, 08:58 PM #2GOLD MEMBER
- Join Date
- Jun 2005
- Location
- Helensburgh
- Posts
- 7,696
Set the ribbon to auto and use control + F1 to bring it up?
CHRIS
-
7th October 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.
-
13th December 2019, 10:01 AM #4
Well that was a decision to take no further action that was well advised.....
After a small Windows update 2 days ago the Ribbon is displaying as it should! All the real estate is gone and the icons are nicely packed in like this, even when I have the sheet displayed narrower.
This does mean that I am now sending the cursor to the wrong place for the frequently used icons (and I use a superfast pen/tablet rather than a mouse), but I'll get over that pretty quickly. Just a bit brain re-routing required.
-
13th December 2019, 02:37 PM #5SENIOR MEMBER
- Join Date
- Mar 2018
- Location
- Sydney
- Posts
- 469
Could you create a new tab on the ribbon to break it up a little?
I tend to keep my home with the near standard setup, shoving other frequently used ones to a secondary custom one.
Regards.
Adam
Sent from my SM-G950F using Tapatalk
-
13th December 2019, 03:27 PM #6
No need to now - the pic shows exactly what I want (which is how it first was).
-
13th December 2019, 08:20 PM #7GOLD MEMBER
- Join Date
- Jun 2005
- Location
- Helensburgh
- Posts
- 7,696
Do MS applications such as Excel get updated when the OS does?
CHRIS
-
13th December 2019, 09:36 PM #8GOLD MEMBER
- Join Date
- Mar 2018
- Location
- Sydney
- Posts
- 1,166
Somewhat. It was "Patch Tuesday" this week so on Wednesday our time, the OS updates came out, and there were Office security updates released at the same time. So if you're running a version of Excel that gets security updates (because it's "current" and not out of support - that means Office 2010 or newer at this stage, but Office 2010 is coming to the end of support next year), then this week you would have got Office updates applied as well. There's also usually a reliability/bug fix release made a couple of weeks after this point, but I think they have decided to hold that over Christmas/New Year period.
I expect that the fix for FF's issue was just a bug fix that ended up coming out with this security update.
-
13th December 2019, 10:39 PM #9
Yeah, no mention of Office updates, but why would I expect MS to tell me the whole story eh? Anyhoo, the ribbon back to my liking.
-
14th December 2019, 09:34 AM #10GOLD MEMBER
- Join Date
- Jun 2005
- Location
- Helensburgh
- Posts
- 7,696
My desk top seems to have problems with the newest update for some reason. Yesterday it told me it was updating then re-start to complete them and after that was done the update notification remained. I have never had any issues before so I will see what happens today.
CHRIS
-
15th December 2019, 01:23 AM #11
Had problem with Wife's computer stuck on version 1803 and updates 1903 & 1909 failing. Downloaded Update Assistant from MS ran 1909 update via it and it worked OK.
Sent from my iPad using TapatalkArie.
Similar Threads
-
Ribbon silver solder
By powderpost in forum BANDSAWSReplies: 6Last Post: 1st May 2011, 02:21 PM -
Ribbon Weaving
By RufflyRustic in forum WOOD WHISPERING WOMENReplies: 5Last Post: 24th January 2010, 05:27 AM -
Ribbon casting
By dj_pnevans in forum CASTING & STABILISATIONReplies: 6Last Post: 11th February 2009, 10:01 PM -
The blue ribbon
By Barry Hicks in forum WOODIES JOKESReplies: 0Last Post: 7th December 2007, 05:50 PM