How to increase drop down list font size in Excel?
Drop down list is a very helpful feature in Excel, when you create drop down list in your worksheet, have you ever tried to increase the font size of the drop down list to make the selected record larger and more readable as left screenshot shown? This article will talk about a workaround to solve it.
Combine / import multiple worksheets or csv files into one worksheet or workbook:
In your daily work, to combine multiple worksheets, workbooks and csv files into one single worksheet or workbook may be a huge and headachy work. But, if you have Kutools for Excel, with its powerful utility – Combine, you can quickly combine multiple worksheets, workbooks or csv files into one worksheet or workbook.
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!
In fact, there is no direct way for us to increase the font size of the drop down list, but, you can apply the following VBA code to change the drop down list cells zoom setting to make the text appear larger. Please do as follows:
1. Go the worksheet which contains the drop down list that you want to increase its font size.
2. Right click the sheet tab, and select View Code from the context menu, in the popped out Microsoft Visual Basic for Applications window, please copy and paste the following code into the blank Module window:
VBA code: Increase drop down list font size to enlarge the cell zoom
Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'updateby Extendoffice 20160530 On Error GoTo LZoom Dim xZoom As Long xZoom = 100 If Target.Validation.Type = xlValidateList Then xZoom = 130 LZoom: ActiveWindow.Zoom = xZoom End Sub
3. Then save and close this code, now, when you click the drop down list cells, the cell’s zoom will be enlarged, and the drop down list will be appeared larger, but, when you click other cells not contain the drop down list, the cell zoom will be normal.
Note: In the above code, xZoom = 130 will change the drop down list cells zoom to be 130, you can change this zoom number to your need.
Excel Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 5 months agoHi, Just question i have pasted the code onto blank Module window (Right click in view code). Once i save, is function well that was good. But when i close the file and re-open it, the code was gone and no more enlarge for the drop down list. Can i know how to set for permanent use?
To post as a guest, your comment is unpublished.· 11 months agoHow can I apply this font change size to only one column? I have several columns with drop-down boxes and I only want one specific column to change font size?
To post as a guest, your comment is unpublished.· 1 years agoThis zooms the whole sheet to 130%
How do I increase only the drop menu ?
To post as a guest, your comment is unpublished.· 1 years agoHello, Dave,
To only increase the drop down menu, here is a workaround to solve it.
First, after inserting the drop down list in your worksheet, then you should insert an Combo Box (ActiveX Controls),and then apply the following VBA code into the sheet module code:
Dim xRg As Range
Private Sub ComboBox1_Change()
On Error Resume Next
xRg.Value = Me.ComboBox1.Text
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo LblExit
.Visible = False
If Target.Validation.Type = xlValidateList Then
Target.Validation.InCellDropdown = False
.ListWidth = 120
.ListFillRange = ""
.ListFillRange = Target.Validation.Formula1
.Left = Target.Left
.Top = Target.Top
.Width = Target.Width
.Height = Target.Height
.Font.Size = 16
.Visible = True
Set xRg = Target
After inserting the code, now when you click the drop down list cell, a combo box will be displayed, and font size in the drop down menu is increased as you need. And the inserted combo box will be hidden automatically.
Please try it, hope it can help you!
To post as a guest, your comment is unpublished.· 1 years agoAfter using this code, I can't use return key on Excel. How can I code (install) return key?
To post as a guest, your comment is unpublished.· 1 years agoThis does not work for me. I pasted the text as instructed. When i clicked on the drop down menu the font size was the same. When i then clicked on a different cell, the whole spreadsheet increased in size perhaps by 30%. Really would like a work around if possible