Solved Would like to use drop down menus to filter rows

April 15, 2013 at 22:23:35
Specs: Windows
I have a spreadsheet at work with rows containing three pieces of information, a product, solution text for closed tickets, and a problem summary field. I would like to use a dropdown menu to filter the rows to make it easier to find what I am looking for. For example, choosing windows from the dropdown would display only rows pertaining to the windows product. I do not have experience in Vba coding. Thank you in advance.

See More: Would like to use drop down menus to filter rows

April 16, 2013 at 06:46:57
✔ Best Answer
Right-Hand click on your top row that contains your column headers, click 'Filter' then select 'Filter by Selected Cell's Value'

That should give you a drop down for each column that you can filter your data with.

Report •

April 16, 2013 at 20:53:01
Thanks! Any way to make it just a list instead of all the sort options? So when I dropdown it's just a list of products to sort by?

Report •

April 17, 2013 at 07:51:40
Well, technically, what you're seeing is a list. It's actually an active list. As you add and remove things from the column they should appear and disappear respectively from the filter list.

All you need to do is make sure there's a check next to the items you want to appear in your spreadsheet. For quick use, there's a 'Select All' button that if you check the box it will either select all or unselect all. Hope this helps.

Don't forget to select the best answer to mark this thread as solved if I was able to answer all of your questions!!

Report •
Related Solutions

Ask Question