Prev: Formatting Dates from Text to Numbers
Next: Starting column with 90003 how do I go to next # without typing
From: Joe M. on 4 Jun 2010 09:58 I have some columns with the width 4. Sometimes the validation pick list is wide like 40 and sometimes it is only as wide as the column. I already know there's code to temp make the column wider when you click on it. But this behaviour of the pick list sometimes appearing much wider than the column makes me think there's something influencing the width of the pick list itself. Is there some way to control the width of the pick list without changing the width of the column or is what I'm seeing occur just an Excel bug? Thanks, Joe M. |