Data validation function and drop-down lists

I am sending this to several newsgroups, because I am not sure which one
is the most appropriate.

I am using the "Data Validation" function of Excel to create drop-down
lists. Is there any way to control the font size of the items in the
drop-down list without changing the zoom (view) function of the whole
spreadsheet?

Thank you.
Colleen

No there isn't.

--
Regards,
Tom Ogilvy


"Colleen" <meterri@mindspring.com> wrote in message
news:2jIOf.7354$S25.3378@newsread1.news.atl.earthlink.net...
> I am sending this to several newsgroups, because I am not sure which one
> is the most appropriate.
>
> I am using the "Data Validation" function of Excel to create drop-down
> lists. Is there any way to control the font size of the items in the
> drop-down list without changing the zoom (view) function of the whole
> spreadsheet?
>
> Thank you.
> Colleen

Hi Colleen

As Tom rightly says, there isn't.
However there are a few "tricks" to achieve this if you take a look at
Debra Dalgleish's site
http://www.contextures.com/xlDataVal08.html#Larger
http://www.contextures.com/xlDataVal08.html#Wider

or by adding a Combo Box to the sheet
http://www.contextures.com/xlDataVal10.html


--
Regards

Roger Govier


"Colleen" <meterri@mindspring.com> wrote in message
news:2jIOf.7354$S25.3378@newsread1.news.atl.earthlink.net...
>I am sending this to several newsgroups, because I am not sure which
>one
> is the most appropriate.
>
> I am using the "Data Validation" function of Excel to create drop-down
> lists. Is there any way to control the font size of the items in the
> drop-down list without changing the zoom (view) function of the whole
> spreadsheet?
>
> Thank you.
> Colleen

Thank you for your help.
Colleen

Roger Govier wrote:
> Hi Colleen
>
> As Tom rightly says, there isn't.
> However there are a few "tricks" to achieve this if you take a look at
> Debra Dalgleish's site
> http://www.contextures.com/xlDataVal08.html#Larger
> http://www.contextures.com/xlDataVal08.html#Wider
>
> or by adding a Combo Box to the sheet
> http://www.contextures.com/xlDataVal10.html
>
>