Font Size in Drop Down List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mindie - 10 Jul 2006 20:40 GMT

I have a drop down list where I want to change the Font Size. I have tried
changed it in the cells where the data resides and also in the cells where
you have the drop down list and neither way increase the Font Size. I am
sure it is something very simple that I am forgetting. Hope someone has the
answer.

Reply to this Message

Gord Dibben - 10 Jul 2006 22:54 GMT

Mindie

What type of drop-down list?

Data Validation? Font size cannot be changed although you can use Zoom to
make the whole sheet larger.

See Debra Dalgleish's site for workarounds.

http://www.contextures.on.ca/xlDataVal08.html#Font

Gord Dibben MS Excel MVP

>I have a drop down list where I want to change the Font Size. I have tried
>changed it in the cells where the data resides and also in the cells where
>you have the drop down list and neither way increase the Font Size. I am
>sure it is something very simple that I am forgetting. Hope someone has the
>answer.

Reply to this Message

Mindie - 10 Jul 2006 23:04 GMT

Yes it is Data Validation. Problem is that I do not want to change the whole
sheet, just what is in the drop-down list.

> Mindie
>
[quoted text clipped - 14 lines]
> >sure it is something very simple that I am forgetting. Hope someone has the
> >answer.

Reply to this Message

Gord Dibben - 10 Jul 2006 23:40 GMT

Then you will have to go the Combo-box route.

Did you check out Debra's site?

I'll direct you to another of her pages which shows how to use a Combo-box.

Note:VBA coding required with this method.

http://www.contextures.on.ca/xlDataVal10.html

Gord Dibben MS Excel MVP

>Yes it is Data Validation. Problem is that I do not want to change the whole
>sheet, just what is in the drop-down list.
[quoted text clipped - 17 lines]
>> >sure it is something very simple that I am forgetting. Hope someone has the
>> >answer.

Reply to this Message