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.
--
Mike Lee
McKinney,TX USA

Not possible with DV list alone.

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


Gord Dibben MS Excel MVP

On Thu, 23 Aug 2007 09:52:00 -0700, mikelee101 <mikelee101athotmaildotcom>
wrote:

>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.