how do I insert rows without changing formula

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

Guest

In a cashflow worksheet how can I add rows without having to re-do all the
proceeding formulas.
 
use absolute references e.g.

=$A$5

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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 length array that exludes (possible) blanks in the middle 1
Excel Moving data to sheet2 from sheet1 0
insert row and copy formula in protected worksheet 4
Formula from consecutive rows to alternate rows? 2
how do I keep rows' formats when copying a formula? 2
sum of every forth column to left excel 2
Copy paste data from a column to a row 0
Excel Help to copy information from one row at a time to another sheet 1

Back
Top