HOW DO I ENLARGE THE FONT ON A DROP-DOWN LIST
 

I CREATED A DROP-DOWN LIST IN A CELL BUT THE FONT IS SO SMALL I ALMOST CAN'T
READ IT.

HOW DO I ENLARGE THE FONT ON A DROP-DOWN LIST
 

If it's a dropdown from a forms control, my guess is you've changed the view
from 100%, and it's the nature of the beast. However, if you use dropdowns
from the ActiveX controls, there is the option of making the font much
larger.

Bob Umlas
Excel MVP

"MARK M" <MARK wrote in message
...
I CREATED A DROP-DOWN LIST IN A CELL BUT THE FONT IS SO SMALL I ALMOST
CAN'T
READ IT.

HOW DO I ENLARGE THE FONT ON A DROP-DOWN LIST
 

Mark, if its from Data Validation there is not a way from excel, have a look
here for a workaround,
http://www.contextures.com/xlDataVal08.html#Font
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"MARK M" <MARK wrote in message
...
I CREATED A DROP-DOWN LIST IN A CELL BUT THE FONT IS SO SMALL I ALMOST
CAN'T
READ IT.