Subtotals Problem when Filtering

B

Brenda Rueter

When I do a subtotal of data, there is the collapsable column to the left,
the 1, 2 and 3 that allow me to collapse the data down to just the subtotals
lines or the grand total line. However, if Autofilter is turned on and a
filter is applied to the data, THEN subtotals is run, there is no 1 2 3 to
the left so I cannot collapse the data.

Am I doing something wrong or is there something else I need to know about?
Do I have to select all the visible cells and copy to another sheet before I
can run the subtotals and be able to collapse the data? TIA!
 
G

Guest

AFAIK,
That, unfortunately, is the way Excel works. SubTotals and Filtering do
not go well together.
Gary Brown
 
B

Brenda Rueter

Thanks Gary. That does seem incredible to me; however, that's my
experience, too. It sure seems like a spreadsheet being used as a database
(nothing is particularly relational here!) could be filtered and subtotaled.
Guess we'll have to do it the hard way. Sigh... Perhaps someone has a
better suggestion???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top