When you insert a row to a sheet with formulas (that proceed down a
column, e.g. a 'running total' for example), the formula doesn't
appear in the inserted row?

I know you can copy/paste the formula manually, but since the formula
applies to each row, why doesn't the program put it there
automatically?

I am using 2000, build 9.0.6926 SP-3

Thanks,
Lee Bowman

Here's a workaround: copy one of the rows that has the formulas. Go to the
row above which you want the insert, and select the entire row. Press Ctrl
and the + key on the keypad. This inserts a complete copy of the row you
started with. Leave the formulas, and just change or delete the other data.
Unless the formulas contain absolute references (with $ signs), the new
row's formulas will pertain to that row.

"Lee Bowman" wrote in message
...
When you insert a row to a sheet with formulas (that proceed down a
column, e.g. a 'running total' for example), the formula doesn't
appear in the inserted row?

I know you can copy/paste the formula manually, but since the formula
applies to each row, why doesn't the program put it there
automatically?

I am using 2000, build 9.0.6926 SP-3

Thanks,
Lee Bowman

Try using:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"Lee Bowman" wrote in message
...
When you insert a row to a sheet with formulas (that proceed down a
column, e.g. a 'running total' for example), the formula doesn't
appear in the inserted row?

I know you can copy/paste the formula manually, but since the formula
applies to each row, why doesn't the program put it there
automatically?

I am using 2000, build 9.0.6926 SP-3

Thanks,
Lee Bowman