View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default Font size in data validation drop down lists

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" wrote in message
...
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.