KJP,
Make sure that your range reference for your list of allowable values uses absolute range
references:
Instead of
=G2:G5
that should be
=$G$2:$G$5
HTH,
Bernie
MS Excel MVP
"KJP" wrote in message
...
I can compose a drop-down list of a few products in excel, but when I come to
copy it down the length of the column for a spreadsheet I find the value
range also drops down 1 row at a time so after about 5 rows ive lost all the
drop down entries.
How can I copy the drop-down and paste it as it is the in the first cell?
|