Data Validation/In-Cell Dropdown Lists
 

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.

Data Validation/In-Cell Dropdown Lists
 

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
wrote:

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.