| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add a Subtotal Row to an Existing Table?
How do I add the subtotal row to an existing table without "manually
entering" the formulas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add a Subtotal Row to an Existing Table?
I'd sort the data by my key field(s).
Then apply Data|subtotals (in xl2003 menus). Josh Doten wrote: How do I add the subtotal row to an existing table without "manually entering" the formulas? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add a Subtotal Row to an Existing Table?
You could enter the formula once, then copy it across the row, is that what
you mean? "Josh Doten" wrote: How do I add the subtotal row to an existing table without "manually entering" the formulas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add a Subtotal Row to an Existing Table?
Sorry, I found it.
Right Click on Table-"Table"-"Totals Row" "Josh Doten" wrote: How do I add the subtotal row to an existing table without "manually entering" the formulas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| I need to scale existing table data. | Excel Discussion (Misc queries) | |||
| Keeping existing data in table | Excel Discussion (Misc queries) | |||
| Transfer to an existing Access Table | Excel Discussion (Misc queries) | |||
| How do I add another name to an existing table with formulas to w. | Excel Worksheet Functions | |||
Hybrid Mode
