Give your list of items a defined name like MyList

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

Select A1:A10

DataValidationAllowList

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
wrote:

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!