Share via

Excel on Mac: Empty Drop-Down Menu (Data Validation)

Anonymous
2023-10-27T16:00:48+00:00

Hey folks -

I'm working with Excel 16.78 on the Mac and I have a worksheet with a few drop-down menus for their cells. All created with the Data Validation tool. The drop-down arrow appears and works fine. The list appears when the button is pressed. But the numbers in the list aren't shown on screen. They're there: if I select one of the "blank" entries in the list, Excel puts the number into the cell as expected. But I sort of have to guess which number is where on the list.

Even the scroll bar in the list is showing.

It's the same way for all four of the cells I have data validation set up in. And the funny thing is: if I hand this file to someone else, they can see the list fine on their own Excel installation.

Troubleshooting: I've deleted Excel off my Mac and re-installed it. That didn't seem to help. I'm sort of stumped as to what else I might try. Any suggestions?

Thanks!

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 No comments

Answer accepted by question author

Bob Jones AKA CyberTaz MVP 435.9K Reputation points
2023-10-28T19:16:30+00:00

The mouse should do the same.

I believe you've discovered what I consider to be a bug. Please use Help> Feedback in the Excel menu to report it to the development team. Include a reference to this thread.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

Answer accepted by question author

Bob Jones AKA CyberTaz MVP 435.9K Reputation points
2023-10-28T16:10:53+00:00

After playing with this for some time I believe I may have been able to reproduce it or a related issue. I'm not sure because the list content does appear when the list is first opened. However, if you position the pointer within the list & slightly "scroll" left/right a bit the content moves out of sight but returns when you scroll back in the opposite direction. Can you see whether this may be the case?

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

7 additional answers

Sort by: Most helpful
  1. Anonymous
    2023-10-27T17:11:16+00:00

    Are you using Excel in a web browser or on the desktop?

    If you are using the desktop app, which version are you running? Use the Menu Bar and choose Microsoft Excel > About Microsoft Excel to display the version.

    Desktop, version 16.78 as I posted in the OP.

    Was this answer helpful?

    0 comments No comments
  2. Bob Jones AKA CyberTaz MVP 435.9K Reputation points
    2023-10-27T16:08:22+00:00

    Have you tried restarting the Mac?

    Which specific version of macOS are you running? If you've adopted Sonoma it may be a font issue. Make sure to apply the 14.1 update followed by a restart.

    Was this answer helpful?

    0 comments No comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2023-10-27T16:03:13+00:00

    Hi Jason

    Are you using Excel in a web browser or on the desktop?

    If you are using the desktop app, which version are you running? Use the Menu Bar and choose Microsoft Excel > About Microsoft Excel to display the version.

    Thanks.

    Was this answer helpful?

    0 comments No comments