You can use a named range as the list source, as described he

http://www.contextures.com/xlDataVal01.html

or use an absolute reference to the list, e.g.: =$A$1:$A$6
instead of a relative reference: =A1:A6

Paul wrote:
Making a schedule 21 days across by 12 rows down. I want to make a drop down
list of employees names and have the same list available in each cell. I use
the data, validation steps to create the lists, but Excel automatically
changes the coordinates of the data in each horizontal or vertical cell.

How do I make an IDENTICAL drop down list of employees show up in each cell?

This has frustrated me so badly that the dog assumes I'm going to kick him
and hides everytime I open an Excel spreadsheet. (well, if I really had a dog
to kick he would)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html