How to Change Drop Down Width and Font Size in Excel

In this video, I’ll show you how to increase the width of a drop-down box in cases where the entries are too long. We’ll also look at increasing the font on hard-to-read drop-down menus.

Related Videos:

Searchable Drop Down Lists in Excel - The List Search Add-in:

#MsExcel #ExcelCampus
00:00 Introduction
00:16 Change Drop Down Width
01:25 Merge and Center
03:19 Change Font Size

[billynhk]

quick and clear tutorial on the needs. good native english speaking as well. I love that.

[maryscaletta]

Is it possible to increase the LENGTH of the drop down box so you don't have to scroll so much? Thank you!

[bobwhelan]

Jon - I have only just found you! I could have done with you months/years ago, and will definitely need you in the months/years ahead! You have a new subscriber - great content, great presentations, thank you.

[sarahkplim]

Like your presentation. It very clear and very useful. Thank you

[patrickschardt]

I never noticed that drop down list width was dependent on the cell width. That’s neat

Thanks for the tips

[brandon.T]

Another fantastic video, John! I have always wondered how you make your videos. Would you be willing to share your secrets? What apps are you using & what is your process? Thank you, Sir!

[darrylmorgan]

Really Helpful Tips...Thank You Jon :)

[OlabanjiAyodele]

Great video. Possible to share your emal?

[briananderson]

Any update on increasing the font size (usability) of a dropdown list? I increase the zoom on my spreadsheet to 300% and still can't hardly use the tiny dropdown data. I'm in the field with a tablet trying to tap tiny numbers with a fingertip.

[TobiasELee]

That was great - thank you! I THINK this should fix the trouble I have - the text is WAY to small to read when I print it out. Thank you again!

[nadermounir]

Thank you very much Jon. This is great tutorial 👌

[sree]

Jon, this is not working in data filter drop down list.

[koschi]

Thanks for the video. It was helpful. Is there a way how to see more lines in the drop down list? At this moment I see 8 lines. Let's see that I would like to see all 15 I have in the validation list. Reason why - I am not able to use the scroll button of the mouse, need to pull the bar on the right side of the drop down list.

[guadalupearagon]

Hi! This is great! I am an instructor and have created an assignment in word. I am working really hard trying to make assignments accessible! I tried doing what other tutorials say to do and when I do everything I hit okay and the only thing that changes is the color around the drop down list! Argh!!! Do you have this tutorial for microsoft word? Sincerely Grateful, Guadalupe!

[mariab]

I watched your video, it was exactly what I needed. I want to change the colour of the names in the drop down menu, is that possible? Thank you

[JP_]

I avoid issues with "Merge & Center" by instead using "Format / Center Across Selection". I am not aware if that would work for your example in this video or not.

[Jayhawker]

Thanks Jon! Is it possible to make the drop down window taller? I have a situation where if it was just a bit taller I wouldn't need to use the scroll bar for my selection.

[danpaulmier]

looking for a way to have entire list show when users click on the dropdown arrow. Better yet, a way that a user can begin typing and options that begin with the typed letters show in the dropdown for selection (not looking to utilize the search) thx!

[mohammedismail]

thnx alot
is ther a way to change the size of sheets in excel ?

[abdobassel]

All this is easy to find out by my self, but if I want to change text size of the drop down this is the hard think...
If you know how to do that please tell me
I think you must to do something with combo box if you want that, but I don't know the steps 😐💔