Hi Wayne

depends how you created the drop down list -
as you mentioned data / validation i'll assume that your list is a data /
validation list that you typed into the source field - if so,
click in a cell with the drop down list and choose data / validation
click in the source box and use CONTROL & C to copy the information
go to a blank cell somewhere or your word document and paste
in excel the data will appear as a comma separated list, to split it up into
different cells, click on the list, choose data / text to columns, choose
delimited, next, untick tab, tick comma - finish
in word, select your comma separated list, choose table, convert, text to
table, choose comma click OK

Cheers
JulieD


"Wayne" wrote in message
...
If I have a drop-down menu in my Excel spreadsheet, how can
I copy all of the data in this drop-down menu, and paste it
into/onto either a normal Excel spreadsheet cells, or even
on to a word file?