filters

[Guest]

how do i have filters on multiple column of the same worksheet

 

[JulieD]

Hi mukesh

if the columns are adjacent (ie no blank columns between), then selecting
one cell only and then choosing Data / Filter / AutoFilter should give you
autofilters on all adjacent columns.

if they're not adjacent then i don't think you can do it ... but someone
else might have a solution for you.

Cheers
JulieD

 

[Guest]

Hi

A possibility would be select the whole row or select the cells you wish to filter on and do as JulieD mentioned. This should work

Regards
Bernd

 

[Dave Peterson]

Just to add:

each worksheet can have one range with a filter. That range can have multiple
columns (multiple dropdown arrows).

But you can't have multiple areas with filters on them at the same time.

I don't like to let excel guess at my range that I'll filter. I select the
bottom right corner through the top leftcorner (last row of the header) and then
apply data|filter|autofilter.

But if you have a range (say A2:Z99) that's filtered, you can actually hide the
dropdown arrows on some of the columns. But you have to use a macro.

Debra Dalgleish has some sample code at:
http://www.contextures.com/xlautofilter03.html#Hide

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm