Sir Babydum GBE
06-22-2005, 04:21 AM
OK, I guess this is gonna be a 'yes' or 'no' thing, so here goes.
On xl97 (possibly the other versions too) When you create a validation list, the things validated may include rather long expressions.
Now, you may want to resize the column on which the list appears and wrap the text so that the column doesn't have to take up the whole flippin' page. But have you noticed that the validation drop-down list get's narrower as your column does - and the choices available to the user are not wrapped - which means they can't see the darned things properly. This usually results in a barrage of "I hate your spreadsheet" insults from the poor people who have to use them. :motz2:
As much as i try to have wide shoulders(:mkay ), I'd still like to know if there any sort of option or code that can wrap the text in the validation drop-down list - or perhaps make the drop-down list wider?
This would solve one of my long-time pet peeves with Excel, and could even restore peace and harmony in the universe. The benefits could be endless. :wot
On xl97 (possibly the other versions too) When you create a validation list, the things validated may include rather long expressions.
Now, you may want to resize the column on which the list appears and wrap the text so that the column doesn't have to take up the whole flippin' page. But have you noticed that the validation drop-down list get's narrower as your column does - and the choices available to the user are not wrapped - which means they can't see the darned things properly. This usually results in a barrage of "I hate your spreadsheet" insults from the poor people who have to use them. :motz2:
As much as i try to have wide shoulders(:mkay ), I'd still like to know if there any sort of option or code that can wrap the text in the validation drop-down list - or perhaps make the drop-down list wider?
This would solve one of my long-time pet peeves with Excel, and could even restore peace and harmony in the universe. The benefits could be endless. :wot