Font Size in Drop Down Lists (e.g. AutoFilter)

[Guest]

When using the "Autofilte"-Function or the "Valdation/Choose from
List"-function, In-Cell Drop Down Lists are used to choose the data.
The values in those lists seem to be shown in a standard font. How can I
change the size of this font?

Thanks!

 

[Debra Dalgleish]

You can't change the font size in the AutoFilter dropdown list.

If you increase the zoom setting for the worksheet, the font will appear
larger.

 

[Roady]

Hi Debra:

I followed the Contextures instructions for adding a module so that anytime
a drop down data validation is selected, it will zoom. However, I find that
it is working on some of the data validation lists and not others. Do you
have any idea why?

thank you!
Roady

 

[Roady]

One more thing- I just realized that the columns that it will not perform the
zoom on happened to be merged cells with data validation lists. Any idea how
I could solve this?

thanks!!

 

[Gord Dibben]

Getting rid of the merged cells would be the easiest and would prevent the
problems that will most assuredly arise with merged cells.

Why would you need the DV dropdown cells to be merged?


Gord Dibben MS Excel MVP