Thanks Thanks:  0
Likes Likes:  0
Needs Pictures Needs Pictures:  0
Picture(s) thanks Picture(s) thanks:  0
Results 1 to 3 of 3
  1. #1
    FenceFurniture's Avatar
    FenceFurniture is offline The prize lies beneath - hidden in full view
    Join Date
    Oct 2010
    Location
    1017m up in Katoomba, NSW
    Posts
    9,260

    Default 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......)
    Regards, FenceFurniture

    COLT DRILLS GROUP BUY
    Jan-Feb 2019 Click to send me an email

  2. # ADS
    Google Adsense Advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many





     
  3. #2
    Join Date
    Jun 2005
    Location
    Helensburgh
    Posts
    5,912

    Default

    Set the ribbon to auto and use control + F1 to bring it up?
    CHRIS

  4. #3
    FenceFurniture's Avatar
    FenceFurniture is offline The prize lies beneath - hidden in full view
    Join Date
    Oct 2010
    Location
    1017m up in Katoomba, NSW
    Posts
    9,260

    Default

    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.
    Regards, FenceFurniture

    COLT DRILLS GROUP BUY
    Jan-Feb 2019 Click to send me an email

Similar Threads

  1. Ribbon silver solder
    By powderpost in forum BANDSAWS
    Replies: 6
    Last Post: 1st May 2011, 02:21 PM
  2. Ribbon Weaving
    By RufflyRustic in forum WOOD WHISPERING WOMEN
    Replies: 5
    Last Post: 24th Jan 2010, 05:27 AM
  3. Ribbon casting
    By dj_pnevans in forum CASTING & STABILISATION
    Replies: 6
    Last Post: 11th Feb 2009, 10:01 PM
  4. The blue ribbon
    By Barry Hicks in forum WOODIES JOKES
    Replies: 0
    Last Post: 7th Dec 2007, 05:50 PM
  5. Ribbon Plate
    By Metung in forum STRUCTURAL RENOVATION, ROOFING, DEMOLITION, etc
    Replies: 3
    Last Post: 18th Aug 2005, 06:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •