Filtering

  • Thread starter Thread starter Caroline Horner
  • Start date Start date
C

Caroline Horner

Hello

I am working on Excel 2003. I have a spreadsheet with several columns, but
only want to filter, for example, Columns, A, B, C, D and I. How do I do
that. I have used the Autofilter, but it filters all the columns, even when
I only select columns A, B C, D and I?

Any clues anyone?

Thank you in advance

Caroline
 
You have to apply data|filter|autofilter to a contiguous range.

But you can hide the dropdown arrows from any of the columns using some code.

You can use the technique at Debra Dalgleish's site:
http://contextures.com/xlautofilter03.html#Hide


If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)
 
When filtering on any column, rows will be hidden across all columns.


Gord Dibben MS Excel MVP
 
Back
Top