Data Validation

[Guest]

Is there any way I can change the size of the drown down list? My validation
drop down list is really small and I prefer not to zoom in. I just want to
be able to increase the font size of the validation list.

 

[Guest]

Hi,

No. It is not possible. I tried specifiying the list with increased font
size and named the cell range. Then when I call this named range, in the Data
Validation source text box, the font sizes does not reflect in the current
cell position.

Therefore the only thing you can do is as mentioned in the procedure below:

Note: Select the column or a range of cells assign Font size properties
before applying the Data Validation List.

Do one of the following:
1. Click the Font Size box, enetr a font size, or select a font size from
the font list.
-or-
1. On the Format menu, click Cell.
The Format Cell dialog box displays.
2. Click the Font Tab.
3. In the Size box, Enter a value or select a font size from the Size list.
4. Click OK.

Challa Prabhu

 

[Guest]

Challa-

Thanks for your help. What I ended up doing is reducing the size of font of
the entire page so which made the Validation drop down list look bigger.
Thanks.

 

[Dave Peterson]

Debra Dalgleish offers a work-around:
http://contextures.com/xlDataVal08.html#Larger