Validation Pull-Down Lists

  • Thread starter Thread starter luv2waterski
  • Start date Start date
L

luv2waterski

I am using data validation to make a list box with several categories.
After the category is selected, it populates the next list box using
VLookup. However, on both list boxes I can only view 8 lines at a
time. I am asking for assistance in increasing the lines viewable
from 8 lines to about 30 or 40 lines at a time. Thanks for your help.

-Darren
 
On another sheet type or copy the entries you want to see in the drop down list.
Select the cells in the list, click in the name box, (left of the formula bar), type name for the list, press the enter key.
Now go back to Data Validation and in the source =(the name of your list)
 
You must log in or register to reply here.

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

Validation Pull-Down List 5
In excell 2003, increasing number of items shown in drop down list 1
How to limit validation list 3
Validation list with formula? 3
Showing full pull-down list 5
Lookup Function for Data Validation 2
Validation List 2
Totaling VLookup 2

Back
Top