Add a Subtotal Row to an Existing Table?
 

How do I add the subtotal row to an existing table without "manually
entering" the formulas?

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

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?

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?