Changing the size of an In Cell Dropdown?

G

Guest

Hello,
I have data validation set up with the In Cell Dropdown, and the list has 10
values. However, the dropdown only displays 8 rows, so selecting one of the
last two options requires scrolling. Not that big of a deal, but it would be
great if there was a way to have the dropdown show all ten rows.
Is it possible to do that?

Thanks to all for the help.
 
G

Gord Dibben

Not possible with DV list alone.

See Debra Dalglesih's site for info and instructions for workarounds.


Gord Dibben MS Excel MVP
 

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

Similar Threads

Displaying arrow in a dropdown list within cell 2
dropdown boxes make file size too large 2
Data Validation/In-Cell Dropdown Lists 1
How to change contents of list dropdown 1
Change the length of the dropdown list used to cell entries 3
Data Validation List with blanks 1
VLOOKUP or dropdown in the cell depending on selection in another 1
Change width of dropdown in EditControlShowing event 3

Top