Then, in the Home tab, in the Alignment group, click the Center Text icon (it looks like five lines of text that are centered).
#HOW TO MAKE A DROP DOWN LIST IN EXCEL FONT BIGGER WINDOWS#
We can set the width of the drop-down list by sending a special Windows message to the combo box. Select the desired color in the Colors window, and click OK.īy default, a cell does not have a border. Fixing The ComboBox Drop-Down List Width. Here’s how you can make data validation list appear larger. And even at 100, it can tough to read the tiny print, at the end of a long workday. If you have reduced the zoom setting for a worksheet, it can be difficult to read the items in the list. If you want a different color than is available in the drop-down menu, click the More Colors option (indicated by green arrow). When you create a drop down list with data validation, you can’t change the font or font size.