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.

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


"David T" wrote:

hey Challa-

When I change the font size, only the font changes and not the Drop down
list for the validation. Are there any other options that may change the
font size of the names in the Validation drop down list. Thanks.

"challa prabhu" wrote:

Hi,

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

"David T" wrote:

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.

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.

"challa prabhu" wrote:

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


"David T" wrote:

hey Challa-

When I change the font size, only the font changes and not the Drop down
list for the validation. Are there any other options that may change the
font size of the names in the Validation drop down list. Thanks.

"challa prabhu" wrote:

Hi,

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

"David T" wrote:

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.

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

David T wrote:

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.

--

Dave Peterson