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
 
Top