Changing the size of an In Cell Dropdown?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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 with dropdown list 2
Data Validation List: Text Size Query 2
Dropdown by keyboard 1
Data Validation/In-Cell Dropdown Lists 1
How to change contents of list dropdown 1
Pictures in dropdown lists 4

Back
Top