How do I insert a row & have the existing formulas apply to new ce

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table which has a column that uses a formula. When I insert a new
row in the middle of the table, Excel inserts a blank cell into the column
with formulas, rather than keeping the formula that applies to the adjacent
rows.

How do I insert a row and keep the column with a formula so it applies to
that new row?
 
Click on a row number to highlight the entire row, then right click and
select "copy". While still highlighted, right click on the same row number
and click "insert copied cells". Excel will automatically adjust the
formulas for the new row, unless the formulas are locked with dollar signs
(eg =$A$2 will always reference cell A2, no matter what).
 
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

Excel Help to copy information from one row at a time to another sheet 1
Auto Fill formula when inserting a new line 4
Inserting new rows, which contain the formula in the above the new 5
Automatically copy formulas in selected row into a new row? 3
how do I insert row keeping formulas from previous row? 1
Inserting multiple rows 2
sum to recognize new rows 3
Excel VBA 1

Back
Top