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).
 
Back
Top