How do you convert embedded drop-down lists in Excel '97?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Drop Down Lists 9
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Formatted cell column in drop down list 1
Created invoices in Excel - not working in Drive 1
Dependent drop down dynamic range formula, off sheet. 7
Drop Down Lists 2007 10
Excel Lists 4
Excel 2007 / right-click / pick from drop down list 1

Back
Top