Filter Select Columns Only

  • Thread starter Thread starter Mike G.
  • Start date Start date
M

Mike G.

Dear Gurus and Experts:

You help expand my knowledge in some many ways and I
appreciate that.

Today's challenge :>) is to manually turn on the filter
for 1 or more columns that are NOT adjacent.

Looking forward to your help and guidance.

Best regards, Mike
mailto:[email protected]
 
Mike, select and hide the intervening columns (Format > Column > Hide), then
filter the remaining columns as you normally would (Data > Filter >
AutoFilter).

You can also save this as a custom view (View > Custom Views > Add).
 

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

Say 'YES' to overwrite file 6
Close a workbook 1
VBA to Filter on variable column 5
Adding row Macro 2
Merge Cells in a column Macro 1
Collapsing all groups 0
Expand Selection in Auto filter 7
Append Spreadsheets 1

Back
Top