data->validation-->LIST

  • Thread starter Thread starter Mike S
  • Start date Start date
M

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.
 
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
 
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
 
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

Gord Dibben said:
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
Click to expand...
 
<smack>

Data validation + merged cells = increased likelihood of odd behaviour
(in the data validation dropdowns, not the user)
 
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
 
Back
Top