Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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

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.

share|improve this answer

Merge some adjacent cells.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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