If you subtotal the sheets there are three little buttons that appear at the
top left that allow you to view all data with subtotals included, just the
subtotal and grand total data, or just the grand total.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Firemann59" wrote in message
...
I have not used pivot tables so if you can send me links to help get me
started that would be appreciated. Thanks.

"Jim Thomlinson" wrote:

Depending on how you are filtering your data you are probably better off
using a pivot table. It will handle both the filtering and subtotaling in
one
convenient package...

To get started on that make a copy of the sheet. Remove all of the
filtering
and subtotaling. Select Data- Pivot Table and then follow the wizard...
If
you are unfamiliar with pivot tables just reply back and I can send you a
few
links to get you going...
--
HTH...

Jim Thomlinson


"Firemann59" wrote:

In Excel, I am filtering data and then using subtotals. I then need to
hide
all rows except the total rows and keep the totals intact. Is there a
way to
do this?