Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Anyone know what would cause data validation pop-downs to become much wider
than the column width? The list range has not changed. The data in the list range has not changed. The number of characters of the longest item in the list still fits into the cell that has the attached pop-down, but now the pop-down is several columns wider. Until now it has been the same width as the destination cell. I've done some sheet formatting, inserted a column, etc. Typical stuff that I wouldn't expect to have an effect on the pop-downs but, you never know. It's as if the width of the pop-down has picked up the width of the wrong column since I did the insert. But it also affected a pop-down to the left of where I inserted the column. I've tried removing all data validation on the entire sheet and recreating them but to no avail. Has this ever happened to anybody else? TIA Charlie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional data validation drop downs | New Users to Excel | |||
Validation Drop Downs within a List | Excel Programming | |||
Data validation drop downs don't recognize dynamic named range | Excel Discussion (Misc queries) | |||
drop downs & data validation | Excel Discussion (Misc queries) | |||
Drop Downs- Validation | Excel Programming |