Data Validation "List" - Setting length of list shown
 

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

Data Validation "List" - Setting length of list shown
 

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

Data Validation "List" - Setting length of list shown
 

You can use a combo box from either the Forms toolbar or the Control toolbox
and set the number of items displayed.

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
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

Data Validation "List" - Setting length of list shown
 

Thanks.

"Dave Peterson" wrote:

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