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

Advertisements

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
 

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

Top