Not using data|validation.

Dave wrote:

I am using a data validation that covers 26 rows of a list. When you click
the cell with the drop down, only 8 items of the 26 show. You have to use
the scroll bar on the right side of the drop down to see the remaining items.

Is there a way to set the DV/drop down to show all 26 items when you click
the arrow?

I appreciate any help.

Thanks
Dave

--

Dave Peterson