data->validation-->LIST

[Mike S]

how can i use large names in the data validatin using a
the list options. The root cell I can wrap the text using
cell format. does the drop down list expand more than the
root cell using some option.

 

[Frank Kabel]

Hi
if I understood you correctly you can't do this. For a workaround see:
http://www.contextures.com/xlDataVal08.html#Wider

 

[Peo Sjoblom]

What is the root cell, the cell with validation.
To get longer names in the dropdown you have to widen the column

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Gord Dibben]

I should get slapped upside the head, but if you don't want to widen the
entire column you could "merge" several cells horizontally before setting your
DV in that merged cell.

Just be sure that cell will not be part of any range you need to copy, sort or
do similar operations upon.

Gord Dibben Excel MVP

 

[Peo Sjoblom]

I'm sure I can do that for you next summit? <bg>

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

I should get slapped upside the head, but if you don't want to widen the
entire column you could "merge" several cells horizontally before setting your
DV in that merged cell.

Just be sure that cell will not be part of any range you need to copy, sort or
do similar operations upon.

Gord Dibben Excel MVP

 

[Debra Dalgleish]

<smack>

Data validation + merged cells = increased likelihood of odd behaviour
(in the data validation dropdowns, not the user)

 

[Gord Dibben]

I should be good for at least two more smacks before consciousness begins to
dimish to comatose, which state I may have been in when posting the "merge the
cells" suggestion.

Gord