Increase number of items shown in drop down list?

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

I'm using Excel 2003 and want help adding items to an existing drop down list.
 
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
 
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

Filtered drop down list 2
Increase font size in Drop-Down List 1
Lengths of LISTS 3
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