Creating drop downs for multiple cells

  • Thread starter Thread starter Colee Bugg
  • Start date Start date
C

Colee Bugg

Hello All,
I am trying to creat a spread sheet that contains dropdowns, the problem
that I am having is that the cells contain the same information from the drop
downs and I am wanting to know how to create drop downs for multiple cells
without having to creat a drop down in every cell everytime with the same
information.
Thank you!
 
Give your list of items a defined name like MyList

Then.......................

Select A1:A10

Data>Validation>Allow>List

Enter =MyList in the Source dialog.

All selected cells will have the same list in a dropdown.


Gord Dibben MS Excel MVP

On Wed, 11 Feb 2009 11:05:03 -0800, Colee Bugg <Colee
 
Back
Top