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
 
Back
Top