Hi,
When you use the zoom control to see more columns of your data on the screen, the size of the text in a drop down list also decreases as you zoom in. Is there a setting where you can keep the size of the text in the drop down list a a level where it stays easy to read?
Thanks
Unfortunately, you can't change the font size or styling in a drop-down list that is created using data validation.
You can style the text in a combo box, however. Follow the instructions here: Excel Data Validation Combo Box
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Have tried the link as requested but am not getting it to work. Am using in my data validation parameters I have a formula for the list:Originally Posted by mikeTRON
=IF(F30="",Product_List,INDIRECT("fakelist"))
Also my dropdown reference is in a different worksheet called "Dropdown", but do not think that matters as it is a named range being referred to?
Last edited by slabs; 06-17-2016 at 08:07 AM.
Perfect! That will work for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
slabs 
Register To Reply
Bookmarks