Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Sid R
Sid R asked in Computers & InternetProgramming & Design · 9 years ago

I would Like to create each column as a drop down list in Excel 2010.?

Hi, I would Like to create each column as a drop down list in Excel 2010. I want the user to be able to add more values in that column and once the user selects an option within the column from the drop down menu the user should be able to see the entire row (only) of that selected option.There should also be an 'ALL' option which will should display all the values again in all the columns once that is selected from the drop down list. It is an assignment and I would really appreciate any help in this regard.

Thanks.

1 Answer

Relevance
  • garbo7441
    Lv 7
    9 years ago
    Favorite Answer

    Explore the 'Filter' feature in the Data tab.

    Make sure the first row in your column is a heading.

Still have questions? Get your answers by asking now.