WebMay 27, 2016 · 100% is the normal size. If you are using a smaller size like 70% and compensating by using a larger font size you are causing problems for yourself. If you are using something other than Data Validation for the drop down list, ActiveX or Form Controls, there is sizing available in the properties of that type of drop down list. Confession: the heading above is a little misleading because technically you cannot change the font of a drop-down list. However, we canmake the menu bigger and easier to readusing a workaround. The solution forincreasing the readability of drop-down text is to change the zoom levelon the sheet. To adjust the … See more When working with drop-down lists, one common question I get is “How do I make it wider?” That's because oftentimes users are unable to read the longer selections in the drop-down menu. The length of the drop-down box isnot … See more Sometimes simply widening the column is not a good solution because it may mess with the format of cells further down the worksheet. For … See more I hope these tips have been helpful. Here are a fewrelated poststhat you might be interested in reading: How to Create Drop-down Lists in Cells … See more

making the font bigger in the validation list tool drop-down

WebFeb 9, 2014 · A data validation list is sized according to the font size of the cell where it is used At 20% Zoom, you will need to increase the size of those cells to make them reaable You could possibly use a macro to change the cells … WebJul 9, 2024 · 2 Answers Sorted by: 1 I needed a drop down list in column E to be larger to be readable. The following macro zooms to 100% if I click on any cell in column E past … severins gmbh facebook

How to show/display more than 8 lines in data validation list in …

WebJun 20, 2024 · When you create a drop down list with data validation, you can’t change the font or font size. If you have reduced the zoom setting for a worksheet, it can be difficult … WebJan 19, 2024 · With the combo box, you can have your entries autocomplete, and set a bigger text size. Click a data validation cell to make the combo box appear. Introduction. Create Excel Data Validation Dropdown List. Add the Combo box. Open the Properties Window. Change the Combo box Properties. Exit Design Mode. Add the Code. WebSep 25, 2012 · To make the data validation text appear larger, you can use a bit of VBA code to increase the zoom setting when a data validation cell is selected. (Note: this … severin popcorn maker