Increase number of items shown in drop down list?

M

muddan madhu

select the cell which validation.
Go to Data | Validation | increase source list as u need it
 
P

Pimamedic

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
Increase font size in Drop-Down List 1
How to Update drop-down list? 5
increase number of items shown in drop down list? 12
How to make items in a drop down menu reference a number 2
Drop down list 4
empty cells in the drop down list 7
Data Validation - In cell drop Down List 1

Top