Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
Hi, This is Pritesh from India. Recently I have came across a copy of Excel
file, which had Data Subtotals function applied to it's Rows as well as Columns. I have been using Subtotals function for Rows, but, don't know how to apply this to columns (subtotals of columns). Can someone explain me the procedure? Is it available in Office 2002? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
Hi
Try to use Pivot table. If you are not clrear, please mail to with sample file. "Pritesh" wrote: Hi, This is Pritesh from India. Recently I have came across a copy of Excel file, which had Data Subtotals function applied to it's Rows as well as Columns. I have been using Subtotals function for Rows, but, don't know how to apply this to columns (subtotals of columns). Can someone explain me the procedure? Is it available in Office 2002? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
If you're seeing the outlining symbols across the top (to hide/show columns),
you can accomplish this by selecting columns and doing: Data|Group and Outline|Group Pritesh wrote: Hi, This is Pritesh from India. Recently I have came across a copy of Excel file, which had Data Subtotals function applied to it's Rows as well as Columns. I have been using Subtotals function for Rows, but, don't know how to apply this to columns (subtotals of columns). Can someone explain me the procedure? Is it available in Office 2002? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
Hi Dave.
Thanx. This helped me. I came to know that what I have seen was grouping of columns and not Subtotals. "Dave Peterson" wrote: If you're seeing the outlining symbols across the top (to hide/show columns), you can accomplish this by selecting columns and doing: Data|Group and Outline|Group Pritesh wrote: Hi, This is Pritesh from India. Recently I have came across a copy of Excel file, which had Data Subtotals function applied to it's Rows as well as Columns. I have been using Subtotals function for Rows, but, don't know how to apply this to columns (subtotals of columns). Can someone explain me the procedure? Is it available in Office 2002? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Presenting Subtotals only | Excel Discussion (Misc queries) | |||
Subtotals adding a description next to the subtotals | Excel Worksheet Functions | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) |