This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Answer accepted by question author
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.
Answer accepted by question author
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?
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?
Nice catch Bob. I opened the worksheet on my laptop (with touch pad) vs my Mac Pro (keyboard and mouse) and tried side-scrolling. And the numbers appeared. It's like the menu created a right-justified list with a character or two's worth of filler space.
I wonder if there's something similar I can do with a mouse on my Mac Pro.