MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Please help adjust font size in pull down lists.

Posted by Dave V. on March 23, 2001 5:39 PM

In data validation, my users can't see the words as they are too small. Is there a way to enlarge the font size??? Thanks.

Posted by Dave Hawley on March 23, 2001 8:39 PM

Hi DaveV

I don't think so as this is hard coded into Excel. If the list is too small to read it could be due the Worksheet becoming corrupt somehow. Try putting the same validation list on another Worksheet or even another workbook!


OzGrid Business Applications

Posted by Dave V. on March 24, 2001 3:01 PM

Re: Thanks Dave

Thanks for the input, Dave. I was having trouble because we were viewing the sheet in page-break format, so as to see more of the data at a glance. It doesn't seem to happen in normal view. Thaks again. -DV