software

When using the quot;Autofiltequot;-Function or the quot;Valdation/Choose from
Listquot;-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:
gt; When using the quot;Autofiltequot;-Function or the quot;Valdation/Choose from
gt; Listquot;-function, In-Cell Drop Down Lists are used to choose the data.
gt; The values in those lists seem to be shown in a standard font. How can I
gt; change the size of this font?
gt;
gt; Thanks!
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlHi 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

quot;Debra Dalgleishquot; wrote:

gt; You can't change the font size in the AutoFilter dropdown list.
gt;
gt; If you increase the zoom setting for the worksheet, the font will appear
gt; larger.
gt;
gt; Zinewowe wrote:
gt; gt; When using the quot;Autofiltequot;-Function or the quot;Valdation/Choose from
gt; gt; Listquot;-function, In-Cell Drop Down Lists are used to choose the data.
gt; gt; The values in those lists seem to be shown in a standard font. How can I
gt; gt; change the size of this font?
gt; gt;
gt; gt; Thanks!
gt; gt;
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

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

quot;Roadyquot; wrote:

gt; Hi Debra:
gt;
gt; I followed the Contextures instructions for adding a module so that anytime
gt; a drop down data validation is selected, it will zoom. However, I find that
gt; it is working on some of the data validation lists and not others. Do you
gt; have any idea why?
gt;
gt; thank you!
gt; Roady
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt; gt; You can't change the font size in the AutoFilter dropdown list.
gt; gt;
gt; gt; If you increase the zoom setting for the worksheet, the font will appear
gt; gt; larger.
gt; gt;
gt; gt; Zinewowe wrote:
gt; gt; gt; When using the quot;Autofiltequot;-Function or the quot;Valdation/Choose from
gt; gt; gt; Listquot;-function, In-Cell Drop Down Lists are used to choose the data.
gt; gt; gt; The values in those lists seem to be shown in a standard font. How can I
gt; gt; gt; change the size of this font?
gt; gt; gt;
gt; gt; gt; Thanks!
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Debra Dalgleish
gt; gt; Excel FAQ, Tips amp; Book List
gt; gt; www.contextures.com/tiptech.html
gt; gt;
gt; gt;

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 gt;
wrote:

gt;One more thing- I just realized that the columns that it will not perform the
gt;zoom on happened to be merged cells with data validation lists. Any idea how
gt;I could solve this?
gt;
gt;thanks!!
gt;
gt;quot;Roadyquot; wrote:
gt;
gt;gt; Hi Debra:
gt;gt;
gt;gt; I followed the Contextures instructions for adding a module so that anytime
gt;gt; a drop down data validation is selected, it will zoom. However, I find that
gt;gt; it is working on some of the data validation lists and not others. Do you
gt;gt; have any idea why?
gt;gt;
gt;gt; thank you!
gt;gt; Roady
gt;gt;
gt;gt; quot;Debra Dalgleishquot; wrote:
gt;gt;
gt;gt; gt; You can't change the font size in the AutoFilter dropdown list.
gt;gt; gt;
gt;gt; gt; If you increase the zoom setting for the worksheet, the font will appear
gt;gt; gt; larger.
gt;gt; gt;
gt;gt; gt; Zinewowe wrote:
gt;gt; gt; gt; When using the quot;Autofiltequot;-Function or the quot;Valdation/Choose from
gt;gt; gt; gt; Listquot;-function, In-Cell Drop Down Lists are used to choose the data.
gt;gt; gt; gt; The values in those lists seem to be shown in a standard font. How can I
gt;gt; gt; gt; change the size of this font?
gt;gt; gt; gt;
gt;gt; gt; gt; Thanks!
gt;gt; gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Debra Dalgleish
gt;gt; gt; Excel FAQ, Tips amp; Book List
gt;gt; gt; www.contextures.com/tiptech.html
gt;gt; gt;
gt;gt; gt;