Discussion Locked

Data Validation - Dropdown List Control

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there any way to control how a Data Validation dropdown list is displayed? Specifically, I have a data validation list in a cell. The column it is in is only 4 units wide, with the text aligned at 90 degrees (vertically). The dropdown list displayed is also only 4 units wide, and does not show enough characters of each list item. I've seen other spreadsheets where the dropdown list is wider than the column, but it seems to be somewhat random...

Is there any way to increase the size (or other properties) of the dropdown list (apart from increasing the column width)?

2 replies

by j.wallace

Change the source to add a longer choice at the end of the list.

Hoping this helps,
Rick

This discussion is closed to new replies.