LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 703
Default Data Validation Pop-downs

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional data validation drop downs Nadine Lewis New Users to Excel 2 March 10th 09 03:21 PM
Validation Drop Downs within a List Robert[_35_] Excel Programming 0 April 20th 07 07:19 PM
Data validation drop downs don't recognize dynamic named range GlenC Excel Discussion (Misc queries) 0 July 19th 06 06:25 PM
drop downs & data validation burgi Excel Discussion (Misc queries) 2 June 23rd 05 09:40 PM
Drop Downs- Validation Julie Excel Programming 0 June 28th 04 01:40 AM


All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"