Font size in a drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-1472046%22%20slang%3D%22en-US%22%3EFont%20size%20in%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1472046%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20increase%20the%20font%20size%20in%20a%20drop%20down%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1472046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1484713%22%20slang%3D%22en-US%22%3ERe%3A%20Font%20size%20in%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1484713%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702657%22%20target%3D%22_blank%22%3E%40BillyHank1402%3C%2FA%3E%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%20best%20to%20my%20know%20you%20cannot%20increase%20the%20font%20size%20in%20a%20drop-down%20list%20with%20data%20validation.%20%26nbsp%3BBut%20if%20you%20are%20using%20form%20control%20then%20you%20can%20list%20increase%20the%20size%20in%20changing%20the%20drop-down%20property.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1819117%22%20slang%3D%22en-US%22%3ERe%3A%20Font%20size%20in%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1819117%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3BCan%20you%20give%20me%20the%20steps%20to%20do%20this%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1820071%22%20slang%3D%22de-DE%22%3ESubject%3A%20Font%20size%20in%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1820071%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702657%22%20target%3D%22_blank%22%3E%40BillyHank1402%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EUnfortunately%2C%20the%20font%20size%20of%20a%20drop-down%20list%20can%20only%20be%20changed%20using%20VBA.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EHowever%2C%20you%20can%20make%20the%20font%20smaller%20around%20the%20drop-down%20box%20(or%20across%20the%20entire%20sheet)%2C%20and%20then%20zoom%20in%20on%20the%20overall%20view.%20In%20this%20way%2C%20the%20font%20in%20the%20drop-down%20field%20is%20also%20displayed%20larger.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20VBA%20code%20%3A%20%3CBR%20%2F%3E%20Alternatively%2C%20only%20with%20a%20little%20trick%20-%20simply%20enlarge%20the%20zoom%20to%2C%20for%20example%2C%20200%20when%20a%20cell%20is%20selected%20with%20a%20dropdown%20(otherwise%20set%20it%20back%20to%20100)%3A%20%3CBR%20%2F%3E%20Change%20event%20must%20be%20incorporated.%3CBR%20%2F%3E%3CBR%20%2F%3EPrivate%20Sub%20Worksheet_Change%20(ByVal%20Target%20As%20Excel.Range)%20%3CBR%20%2F%3E%20On%20Error%20Resume%20Next%20%3CBR%20%2F%3E%20If%20Target.Validation.InCellDropdown%20Then%20ActiveWindow.Zoom%20%3D%20100%20%3CBR%20%2F%3E%20End%20Sub%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Private%20Sub%20Worksheet_SelectionChange%20(ByVal%20Target%20As%20Excel.Range)%20%3CBR%20%2F%3E%20On%20Error%20GoTo%20error%20handler%20%3CBR%20%2F%3E%20If%20Target.Validation.InCellDropdown%20Then%20ActiveWindow.Zoom%20%3D%20200%20%3CBR%20%2F%3E%20Exit%20Sub%20%3CBR%20%2F%3E%20error%20handler%3A%20%3CBR%20%2F%3E%20ActiveWindow.Zoom%20%3D%20100%20%3CBR%20%2F%3E%20End%20Sub%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EWish%20you%20continued%20success%20with%20Excel%20(the%20coolest%20invention%20since%20Chocola%20...%20Uh...%20Microsoft!%20%3A-)))%20%3CBR%20%2F%3E%20And%20...%20Please%20keep%20asking%20here%20-%20I've%20just%20taught%20myself%20Excel%20with%20the%20help%20of%20this%20forum%20...%20Almost%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How can I increase the font size in a drop down list?

3 Replies

Hi @BillyHank1402;

 

Unfortunately best to my know you cannot increase the font size in a drop-down list with data validation.  But if you are using form control then you can list increase the size in changing the drop-down property.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

@Faraz Shaikh Can you give me the steps to do this please?

@BillyHank1402 

Unfortunately, the font size of a drop-down list can only be changed using VBA.

However, you can make the font smaller around the drop-down box (or across the entire sheet), and then zoom in on the overall view. In this way, the font in the drop-down field is also displayed larger.

VBA code :
Alternatively, only with a little trick - simply enlarge the zoom to, for example, 200 when a cell is selected with a dropdown (otherwise set it back to 100):
Change event must be incorporated.

Private Sub Worksheet_Change (ByVal Target As Excel.Range)
On Error Resume Next
If Target.Validation.InCellDropdown Then ActiveWindow.Zoom = 100
End Sub

Private Sub Worksheet_SelectionChange (ByVal Target As Excel.Range)
On Error GoTo error handler
If Target.Validation.InCellDropdown Then ActiveWindow.Zoom = 200
Exit Sub
error handler:
ActiveWindow.Zoom = 100
End Sub

 

Hope I was able to help you.

Wish you continued success with Excel (the coolest invention since Chocola ... uh ... Microsoft! :-)))
And ... Please keep asking here - I've just taught myself Excel with the help of this forum ... almost

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here