| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dropdown lists from datavalidation. | Excel Discussion (Misc queries) | |||
| data validation, totaling values based off dropdown lists | Excel Discussion (Misc queries) | |||
| Multiple Hiding Validation Dropdown Lists | Excel Worksheet Functions | |||
| How to create Dropdown lists not using Data Validation | Excel Discussion (Misc queries) | |||
| how do I add data validation dropdown lists to a Form | Excel Worksheet Functions | |||
Linear Mode
