up vote 2 down vote favorite
1
share [g+] share [fb]

I have quite a few cells with Data Validation with options in the list that are long strings. Short of widening the column, is there any way to widen the drop-down list so that the user can see the options?

I could possibly use the Design Toolbox, but I'd rather keep it simple.

I cannot use VBA for this; there already exist solution using VBA.

link|improve this question
0% accept rate
The solution can't use VBA? – DaveParillo Oct 9 '09 at 16:16
I'd rather not, due to draconian anti-virus/malware restrictions. Just wondering if it could be done easily, via options somewhere. – Chris Gunner Oct 13 '09 at 13:58
feedback

2 Answers

up vote 2 down vote

The short answer is 'No'. The Data Validation feature can be used as a quick-and-dirty replacement for a genuine drop-down/combobox, but it is limited in the amount of features and options.

link|improve this answer
feedback
up vote 0 down vote

Merge some adjacent cells.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.