Greyed out drop down lists

Sally Curtis 0 Reputation points
2024-05-06T20:27:40.9833333+00:00

In Excel, when I click on a drop down list on the tool bar (fill color, Sort & Filter, Auto Sum, etc) all the drop down options are greyed out & I cannot click on any of them.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
    2024-05-07T08:29:25.55+00:00

    Hi,

    Could you provide a screenshot about your problem?

    How did you create the drop down list? Data Validation or Control to create the drop down list?

    Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Sani Garba 1 Reputation point
    2024-05-07T08:47:03+00:00

    If other menu items on the ribbon are equally greyed out, you may need to activate your office subscription.

    0 comments