ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I increase the font of my drop-down menu options? (https://www.excelbanter.com/excel-worksheet-functions/60393-how-do-i-increase-font-my-drop-down-menu-options.html)

heliu8

How do I increase the font of my drop-down menu options?
 
I created a drop-down menu going to Data and then Validation. When I click
on the arrow to drop down the menu, the options appear correctly but in font
so small that I cannot read them. After I click on an option, it appears
correctly in the box. How can I increase this font size so it's legible in
the drop-down menu? The font in the box is fine, it's only in the drop-down
menu that I cannot read it.

Ron Coderre

How do I increase the font of my drop-down menu options?
 
What you're asking for can be done with a bit of Excel trickery....
See Debra Dalgleish's website:
http://www.contextures.com/xlDataVal08.html#Larger

Does that help?

***********
Regards,
Ron


"heliu8" wrote:

I created a drop-down menu going to Data and then Validation. When I click
on the arrow to drop down the menu, the options appear correctly but in font
so small that I cannot read them. After I click on an option, it appears
correctly in the box. How can I increase this font size so it's legible in
the drop-down menu? The font in the box is fine, it's only in the drop-down
menu that I cannot read it.


Duke Carey

How do I increase the font of my drop-down menu options?
 
Debra Dalgleish has instructions on her site

http://www.contextures.com/xlDataVal08.html#Font



"heliu8" wrote:

I created a drop-down menu going to Data and then Validation. When I click
on the arrow to drop down the menu, the options appear correctly but in font
so small that I cannot read them. After I click on an option, it appears
correctly in the box. How can I increase this font size so it's legible in
the drop-down menu? The font in the box is fine, it's only in the drop-down
menu that I cannot read it.



All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com