| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide rows that meet certain criteria in an excel template | Excel Worksheet Functions | |||
| Can I hide rows in Excel 2002 using a formula in a cell? | Excel Discussion (Misc queries) | |||
| How do I delete columns and rows in Excel, not just hide them | Excel Discussion (Misc queries) | |||
| Why do my rows automatically hide in Excel? | Excel Worksheet Functions | |||
| Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions | |||
Hybrid Mode
