M
MDW
Not really a "function" question, but this is the closest NG I could find.
I've been using AutoFilter for ages. In every case I use it, I select the
entire top row (column headers, if you will) for the entire table I want to
filter on. Often, though, there are only one or two columns that I actually
care about filtering.
My question is this - do I NEED to select all the columns from my data set
in order for AutoFilter to work right? Or can I only pick the columns I want?
I've been using AutoFilter for ages. In every case I use it, I select the
entire top row (column headers, if you will) for the entire table I want to
filter on. Often, though, there are only one or two columns that I actually
care about filtering.
My question is this - do I NEED to select all the columns from my data set
in order for AutoFilter to work right? Or can I only pick the columns I want?