Data Validation/In-Cell Dropdown Lists

G

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.
 
G

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
 
Top