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
 
Back
Top