Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto filter on columns
I have used auto filter where the drop down arrow appears in a column header
to allow filtering based on data in the rows. The ease of a drop down box is so much better than typing your selection in Advanced filter. Is there a way to auto filter or any other filter where you can select from the column headers to show only certain columns? My huge spreadsheet has vendors along the top and jobsite locations along the side. I can filter the locations, but would also like to filter the vendors, so that for jobsite 1, 2, and 4, I would like to see vendors X, Y, and AB. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto filter for multiple columns | Excel Discussion (Misc queries) | |||
Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
using auto filter, how to tell what columns are filtered? | Excel Discussion (Misc queries) | |||
restrict columns that have auto filter | Excel Discussion (Misc queries) | |||
Suggestion to add Auto Filter option for columns | Excel Worksheet Functions |