At a client's office last week, I was selecting a pricing option from a data validation drop down list. The worksheet was zoomed to 75%, so we could see more of the data, and the person watching over my shoulder asked, "How can you even read that?"
Good question. Sometimes the font in a data validation drop down is so small that you can barely read the list.
Unfortunately, there's no way to make the font size bigger, which is one of the drawbacks of a data validation drop down list. There are other ways to create a drop down list though, and one of those options might work better in your worksheet.
We'll compare these types of Excel drop down lists:
Data Validation List Form Control Combo Box ActiveX Control Combo Box
Data Validation List
Data validation is a great feature, and you can use creative formulas
Continue reading 3 Types of Excel Drop Down Lists Compared
Recent Comments