Share via

Cannot show Developer tab on Excel

Anonymous
2024-11-01T12:03:08+00:00

I tried all ways I can find to show Developer tab however it does not work. First, There is no customise ribbon function in my screen. I tried shortcut key but it does not work. My goal is to enable multiple selections in pull down list.

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Bob Jones AKA CyberTaz MVP 429.8K Reputation points
    2024-11-01T15:37:07+00:00

    If you are using the Excel Online web app there is no Developer tab available. The Developer tab is included only in the desktop software. In Mac Excel the Developer tab can be activated in either of 2 ways:

    1. Excel> Preferences> View — Put a check in the Developer tab checkbox at the bottom of the pane, or
    2. Excel> Preferences> Ribbon & Toolbar — On the Ribbon page scroll in the right column & check the Developer checkbox.

    Availability also can depend on the Version Number & type of License as indicated in Excel> About Excel.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2024-11-01T13:35:58+00:00

    Press ALT + T + O

    Now Customize Ribbon should be visible

    0 comments
  2. Jim G 133.9K Reputation points MVP Volunteer Moderator
    2024-11-01T16:25:55+00:00

    Vijay is correct but only for Excel for Windows keyboards. Most Mac keyboards do not have the ALT key. The keyboard shortcut to display the Preferences dialog is Command+, for most users.

    0 comments