Filtering

[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

 

[Pete_UK]

Debra Dalgleish shows here how you can hide filter arrows for those columns
you do not want to filter:

http://www.contextures.com/xlautofilter03.html#Hide

Hope this helps.

Pete

 

[Dave Peterson]

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

 

[Gord Dibben]

When filtering on any column, rows will be hidden across all columns.


Gord Dibben MS Excel MVP

 

[Caroline Horner]

Thank you very much!

Appreciate your assistance.

Caroline