Excel Filters

[Guest]

All,

I frequently encounter situations whereby if I am operating a filter on a
particular column in excel it also collapses rows (such as subtotals etc)
that need to remain visible. I recall seeing a mechanism wher you can 'clear'
this issue? Has anyone encountered this issue, and what is the resolution?

many thx,

Don-

 

[Guest]

You can clear an out line by going to Data--Group--Clear Outline

But I'm not sure that's what you're referring to.

Dave

 

[Dave Peterson]

I don't think I'd use Data|Filter|autofilter and Data|Subtotals (to create the
outlining symbols) on the same range.

Even if you modify your filter to show those subtotal rows, you'll find that
=subtotal() will ignore rows hidden by the filter.

I either use data|subtotals (and avoid data|filter|autofilter) and then I use
the outlining symbols at the left to hide/show the details. Remember to look at
those 1 2 3... at the top left. You can hide/show groups quickly.

If I use data|filter|autofilter, I'll put (manually) the =subtotal() formulas at
the top (row 1 has those formulas, row 2 has the headers and the rest is data).
Then when I filter, I can always see the subtotals for that visible range. I
also use window|freeze panes to make sure rows 1:2 are always visible.