Just copy the formula up or down into the inserted row. Excel will make the
adjustments for row reference.
To test this place a formula in a blank cell =(A1+B1). Now copy this cell
and paste it in another cell. You will see the references change to sum the
two cells to the left of your formula.
Pat
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.
