Excel 2010

[BJS]

I posed this question earlier but am still struggling with it, so will try to ask it in a simpler way. My workbook page contains a table of 6 columns and 10 rows deep with a total of each column in row 11. Now I want to add a further 5 rows so I drop the Total row 11 down to fit in the extra lines. Should the totals now in Row 16, automatically update to any data entered into the new rows. At the moment my tables do not add in the new data and so have to highlight the column again and do a Sum function. Will appreciate any advice on this as 1 workbook in particular am constantly increasing the table rows therefore having to recalculate the table sums each time.

[HowardKennitby]

Don't know about Xl2010 but in XL2003 if you have the total as SUM(A1:a10) say, if you highlight as many rows as you wish to add then click on the 'insert rows' button it alters the SUM range correctly.

[sfby]

I'd put SUM(A1:A11) in row 12, leaving row 11 blank. Then when you highlight row 11 & insert any number of rows it will automatically adjust the formula.

[venator]

You could name the bottom row, say "TOTAL" and put =SUM(AI:TOTAL), so you'd not have to change anything if you added rows above.

You put a name in by the Insert name function in Excel 2003, but I bet it's far more of a palaver in 2010....

[Davethedog]

When you data does it say =SUM(G1:G10) or =SUM($G$1:$G$10)

When you add the rows do you add at row 11 or inbetween? I take it you took the advice about automatic/manual

[rojash]

"so I drop the Total row 11 down"
What exactly does that mean?
As others have said, you should be inserting rows at 10 or above, and the range will adjust itself accordingly.

[BJS]

Thank you all for your response. For Davethedog, my Data say (G1:G10) and yes I have checked and doublechecked that the Automatic operation is ticked. Have checked sfby's method and that seems to work OK. Could not manage doing it Howard's or venator's method. Yes compared with all aspects XL 2010 is NOT a good buy fot the amateur user especially a wrinklie like me. it is too advanced and in my humble opinion not as good as previous versions in fact the whole package of Windows 7 have found that it is difficult to use. It is just that stuck in my mind is that with my previous version it was done automatic.

[BJS]

Problem have just tried the row insertion but as I eventually end up with 12 tables on the work sheet have just found out that it inserts rows right through the sheet including the finished tables. Whoops back to the drawing table.

[HowardKennitby]

Put each table on a separate sheet. Use another sheet to collect data from these and produce summaries and reports as required.

[TheNovice]

you need to insert the rows ending at row 9 (not row 10). That is highlight rows 4 to 9 inclusive, select insert rows. Copy the contents from the 'old' row 10 which should now be row 15 to the new row 10 and carry on. The formulae in the totals cell should now have readjusted to include the new range. Hope that makes sense,