Increase number of items shown in drop down list?

  • Thread starter Thread starter Heather
  • Start date Start date
select the cell which validation.
Go to Data | Validation | increase source list as u need it
 
Go to Tools, Data, Validation, in the settings tabs allow list give range
where list can be found. Add to list nad adjust range as needed
 

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

Filtered drop down list 2
Lengths of LISTS 3
Increase font size in Drop-Down List 1
How to make items in a drop down menu reference a number 2
ADD ITEM TO A DROP DOWN LIST? 4
increase number of items shown in drop down list? 12
How to Update drop-down list? 5
Use word to associate an item in validation drop down list 2

Back
Top