Increase font size in Excel 2010 data validation list

[mf1]

Hi All,

I have created an excel pull down menu for the cell using "Data > Data Validation > List, but the text is too small I can't see it. I have the spreadsheet at 20% zoom level and would like it to remain that way.

From my research on the internet, it is not possible, is this correct? If so, can you suggest a work around please.

Cheers,

mf1

 

[Hui]

MF1

A data validation list is sized according to the font size of the cell where it is used
At 20% Zoom, you will need to increase the size of those cells to make them reaable

You could possibly use a macro to change the cells font sizes between data entry and data use modes

 

[mf1]

Thanks for responding Hui,

I should have made myself clearer, its the font size of the text within the drop down box that is too small

 

[Hui]

And that's what my comments applied to

 

[Tharun Kumar G]

Once you select from the dropdown the font changes to the size assigned to the cell. Are you looking to increase the display size in the drop down it self?? not sure if that is possible.

 

[NARAYANK991]

Hi ,

One workaround is to use ComboBox or ListBox controls.

Narayan

 

[Tharun Kumar G]

what is combo box or list box? how do we do that?

 

[SirJB7]

Hi, mf1!
No, you can't change it. The closest workaround it this:
http://www.contextures.com/xlDataVal08.html#Font
Regards!

 

[ThrottleWorks]

@Tharun Kumar G , could you please check below link.

http://chandoo.org/wp/2011/03/30/form-controls/

Might be helpful.

 

[mf1]

Thankyou everyone for your help.