I want to use subtotals in Excel and hide all rows except total
 

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?

I want to use subtotals in Excel and hide all rows except total
 

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?

I want to use subtotals in Excel and hide all rows except tota
 

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?

I want to use subtotals in Excel and hide all rows except tota
 

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?

I want to use subtotals in Excel and hide all rows except tota
 

Jim,
Thank you for your help. I was able to figure out the Pivot Table and it
does what I need.

John,
Thank you for your reply, however in Excel 2003 or 2007 I did not see the
buttons you are talking about.



"John Bundy" wrote:

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?