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

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.

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

Gord Dibben MS Excel MVP

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question