Font Size in Drop Down List

[Mindie]

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.

 

[Gord Dibben]

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

 

[Mindie]

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.

 

[Gord Dibben]

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