I am the recipient of a spreadsheet that has an embedded drop-down list in
each cell that contains multiple lines of data when you click the drop-down
arrow.

I need to validate the content of these drop-down lists, and would like to
convert the contents to display all at once in the cell so I can see the data
without clicking each list open. Essentially, I want to get rid of the
drop-down format and just display all the data at once. Is there an easy way
to make this happen?

The only "help" I can find in the product help refers to lists in Excel
2003. I am using Excel '97 in this office and haven't worked with this level
in some time. Anyone know how to help?

It sounds like Data Validation from the Data toolbar. Click one of the cells
and gp Data Validation. If it is the case there will be a list that the
data is coming from.
Regards,
Alan.
"RavensChild" wrote in message
...
I am the recipient of a spreadsheet that has an embedded drop-down list in
each cell that contains multiple lines of data when you click the
drop-down
arrow.

I need to validate the content of these drop-down lists, and would like to
convert the contents to display all at once in the cell so I can see the
data
without clicking each list open. Essentially, I want to get rid of the
drop-down format and just display all the data at once. Is there an easy
way
to make this happen?

The only "help" I can find in the product help refers to lists in Excel
2003. I am using Excel '97 in this office and haven't worked with this
level
in some time. Anyone know how to help?