copying drop-down lists

[robparkes]

I have made a drop down list with the data => validation => Allow list
function and sourced it to a series of cells in the same spreadsheet.


When i try to copy and paste that cell to the one below it, The list
cells change also.

My question is, how can I copy that cell to other cells and retain the
origional drop-down list?

Thanks!

 

[Jason Morin]

One way is to create a defined name for your list. Select
the range that holds the list, press Ctrl+F3, and give it
a name (for instance, mylist). Now reference it in
Validation with:

=mylist

and copy away.

HTH
Jason
Atlanta, GA

 

[Freemini]

In your first cell the list should have an absolute ref i.e. $A$1:$A$6

When you copy the cell the absolute reference will be transferred.

hth
Mik

 

[Debra Dalgleish]

As Jason said, you can name the list, and refer to the range name in the
data validation dialog box. There are instructions here for naming a
range, or a dynamic range, that expands automatically as items are added:
http://www.contextures.com/xlDataVal01.html

One advantage of a named range is that you can refer to it on a
different worksheet.

However, if you don't name the range, and want to copy the data
validation to other cells, you can use an absolute reference to cells on
the worksheet, e.g.: =$A$1:$A$10

 

[robparkes]

thanks guys! Phew, just saved me a lot of work!