Adding rows to a worksheet with subtotals

B

Bob_Irving

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a worksheet with subtotals, some of which I created using the standard subtotal process, others I added afterwards using different formulas. I now need to add more data to this worksheet and have the new rows subtotalled as well. I don't want to lose the existing subtotal lines as they are complex and would take a long time to re-create. How can I add the extra rows, please?
 
C

CyberTaz

If you're inserting the new Rows (or Cells) within the range of your
calculation the calculation will automatically update to include the newly
added cells. Just Insert the rows or cells within the existing range by using
the Insert menu among other techniques.

HTH |:>)
Bob Jones
MVP Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding columns to a worksheet 1
Adding new data after creating subtotals 4
delete page within a worksheet - How? 3
Quick/efficient way to VBA subtotal 2
rows and columns in spreadsheet 1
SUM not excluding SUBTOTAL lines. 4
Hiding and Unhiding Rows.. Unhide does not work.. 3
unable to paste data into Excel 3

Top