dropdown size for data validation

  • Thread starter Thread starter kurt
  • Start date Start date
K

kurt

I'm using data validation to have users pick an option
from a list. The list has 10 or so options. Is there
any way to make the data validation dropdown show all
items without having to scroll to the bottom?

Thanks
 
No, the dropdown list will show a maximum of eight items at a time.
 
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

Dependent dropdowns 4
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Creating Data Validation Dependent Lists 2
Dynamically load DataValidation List through Source field? 1
Data Validation Lists 1
size of data validation dropdown list 2
using autofilter data 2
data validation 4

Back
Top