+ Reply to Thread
Results 1 to 4 of 4

disabled (greyed out) ribbon icons

  1. #1
    Registered User
    Join Date
    04-15-2015
    Location
    Manchester, England
    MS-Off Ver
    Office14
    Posts
    2

    disabled (greyed out) ribbon icons

    Hello,

    I've been using Excel for quite some time.

    This morning, I must have hit a combination of keys that seems to have resulted in disabling various icons on the menu tabs (For instance, the icons in the Data tab are all greyed out, and in the home tab, the sort and filter and conditional format and format as table icons are greyed out.

    I have a filter active, but cannot now filter or unfilter data using the icon in the filter header row (clicking displays only the cell text and the status, such as 'showing all').

    The issue affects only the one spreadsheet.

    Can anyone suggest what I might have done, and how to undo it, please?

    Thank you in advance,

    Johnny Jebel

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: disabled (greyed out) ribbon icons

    Check the application title bar for the word [Group]

    if present you have multiple sheets selected. Right click sheet tab and Ungroup selected sheets.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-15-2015
    Location
    Manchester, England
    MS-Off Ver
    Office14
    Posts
    2

    Re: disabled (greyed out) ribbon icons

    Fantastic, Andy!

    Thank you so much for the quick response and solution.

    Regards,

    Johnny

  4. #4
    Forum Contributor
    Join Date
    10-02-2008
    Location
    Berkeley, CA
    MS-Off Ver
    Windows 2007
    Posts
    105

    Re: disabled (greyed out) ribbon icons

    Don't know if you need any more information about this, but another source might be
    Enable or Disable custom Ribbon buttons in Excel 2007-2013

    Mac

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How Do I Show Titles to Icons on Ribbon?
    By omaral in forum Excel General
    Replies: 1
    Last Post: 12-31-2014, 06:38 AM
  2. Insert slicer disabled and greyed out
    By ShaliniGomes in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-30-2014, 09:03 PM
  3. Placing icons in own )commandbar2007) in Ribbon.
    By blake20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2014, 06:13 AM
  4. how to activate greyed out ribbon items?
    By techboy in forum Excel General
    Replies: 13
    Last Post: 12-13-2013, 12:33 PM
  5. Ribbon in Print Preview Greyed Out???
    By edilly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2013, 11:58 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1