(Or the 100% button to bring it to 100% zoom.) Click the Zoom button on the View tab.Use the slider in the bottom right-hand corner of the your worksheet.The solution for increasing the readability of drop-down text is to change the zoom level on the sheet. However, we can make the menu bigger and easier to read using a workaround. Increasing the Font Size of a Drop-down ListĬonfession: the heading above is a little misleading because technically you cannot change the font of a drop-down list. Perhaps we will make a post about the pros and cons of Merge & Center using your feedback. If you are one of those people, feel free to comment why specifically it gives you headaches. Some people strongly dislike using Merge & Center because it can cause issues in other areas. The merged cell will adjust as you resize. Note: Even though you have merged and centered cells, you are still able to resize the columns as needed. You can change the alignment back to the left if the centering doesn't work well for your form. In my example, I am merging B7, C7, and D7.īy merging the cells together, you've basically created one really long cell to fit the text of your longer drop-down entries. I can select one or more of the cells adjacent to the drop-down cell and then select Merge & Center on the Home tab. For example, in the form below, widening the column for the drop-down list changes the size of other form fields.Ī workaround/alternative for this problem is to use the Merge & Center feature. Sometimes simply widening the column is not a good solution because it may mess with the format of cells further down the worksheet.

If you want to auto-fit the column, however, you should check your source list to see which entry is longest, then choose that entry in the drop-down, and then auto-fit by double-clicking the border of the column header. You can adjust the column manually by dragging the border of the column header. The simple solution is to widen the column that the drop-down box is in. The length of the drop-down box is not big enough to display the entire text. 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. Dropdown List Width.xlsx Widening Drop-down Lists

Vlookup with drop down mac excel 2013