Font size in data validation drop down lists

R

Ryan

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

Paul B

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

Font drop-down menu very slow 0
How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
How can the font and size of (all) citation numbers be altered? 1
Excel --> Word 4
drop box/data validation help 0
Increase font size in Drop-Down List 1
Text in note pane of "normal" display suddenly much larger 1

Top