insert new row doesn't add formula

  • Thread starter Thread starter kaplonk
  • Start date Start date
K

kaplonk

I have a table A2->M100

In the M Column I have a sum to calculate the total of that row
=SUM(A34:N34) for example

Now if I want to add a row into that table, I click on the number o
the left, that highlights the row then I go insert>>row and that keep
the formatting of the cells.
BUT it doesn't add the =SUM(A54:N54) in the M column, and so I have ha
to edit each cell by hand to get the correct formula.

Is there an easier way to add a row and keep fomulas within that row
but obviously automatically change the numbers to suit the row
 
After you select the entire row, do a Ctl-C to copy all the contents then add the new row. Tha should update the Sum field with the new Row.
 
You must log in or register to reply here.

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

Variable row number in Sum($A$1:A10) formula 3
sum to recognize new rows 3
Copy paste data from a column to a row 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Summing rows using formulas with variables 1
insert row when sum of values equals 100 3
Insert a Row and then Sum 1
Conditional SUBTOTAL in XL210 Table 7

Back
Top