Font size in data validation drop down lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using data validation lists to control user inputs to a spread sheet.
How do I change the font size inside the drop down list?

I have tried changing the font size on the sheet itself & changing the font
size on the list page. I can't seem to find a property setting for this
font size. The only way to make it appear larger is to zoom in on the page.
 
Ryan, you can not change the font size in the drop down list but have a look
here for a work around

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

Ryan said:
I am using data validation lists to control user inputs to a spread sheet.
How do I change the font size inside the drop down list?

I have tried changing the font size on the sheet itself & changing the font
size on the list page. I can't seem to find a property setting for this
font size. The only way to make it appear larger is to zoom in on the
Click to expand...
page.
 

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

Increase font size in Drop-Down List 1
Validation - Drop Down Lists with tiny text 1
Data Validation/In-Cell Dropdown Lists 1
Data Validation 3
Excel 2003. Data/Validation/Settings - Allow/List: sizing list? 1
Font Size in Data Validation Drop Down List 1
Make drop down list in larger font 1
Excel 2007 Drop Down List format 1

Back
Top