Data Validation/In-Cell Dropdown Lists

[Gensler IT]

How do you increase the size of in-cell dropdown lists without changing the
view (zoom) to 100%.

It is quite cumbersome to zoom in and out of larger worksheets.

The font size for in-cell dropdown lists appear to be controlled by the
current view (zoom) setting.

 

[Gord Dibben]

Assuming you mean Data Validation dropdowns, you cannot change the font
size.

Zoom is the only way of icreasing the size.

You can do it automatically as you click on a DV DD cell.

See Debra Dalgleish's site for code.

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

Also see the link provided at that site for using a Combobox instead of DV
DD


Gord Dibben MS Excel MVP

On Tue, 16 Dec 2008 11:16:07 -0800, Gensler IT <Gensler