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!

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.

Zinewowe wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote:

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.

Zinewowe wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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!!

"Roady" wrote:

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

"Debra Dalgleish" wrote:

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.

Zinewowe wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

On Thu, 7 Aug 2008 12:42:00 -0700, Roady
wrote:

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!!

"Roady" wrote:

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

"Debra Dalgleish" wrote:

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.

Zinewowe wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html