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)
My dropdown list as it shows in the latest Excel on my MAC. When I open the same file in Excel 2016 in Windows 10 this what I get
What I see on the Mac is what I want to see in Excel 2016.
Anyone have any ideas on how to fix this. For information, the column width in both cases must remain the same width (3) but I would like users to see the full description in the dropdown.
Thanks,
Tom
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.
See Debra Dalgleish's site for code which makes the DVLisr column temporarily wider when list is selected
http://www.contextures.on.ca/xlDataVal08.html#Wider
Gord
What I don't understand is why the validation shows up correctly in Mac Excel and differently in 2016 Excel in exactly the same (unchanged) spreadsheet.
Hello Tom,
The width of the drop-down list normally depends on the width of the cell that has the data validation. To prevent truncating the entries that are wider than the drop-down list, you'll need to adjust the width of that cell. Another workaround is to resize or widen the column first before creating the data validation.
Feel free to reach out if you require further assistance.