Data Validation

G

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

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
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation 3
How to edit the size of a drop-down list (using data validation)? 1
Validation list in data entry form 4
validation List Size 1
Data Validation List: Text Size Query 2
Data validation text size 1
Data Validation List (Drop Down) Not Showing 2

Top