inserting rows where a formula is inuse for that column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rose - 07 Mar 2008 21:14 GMT

i have a spreadsheet in excel 2003 that i use to figure trucking miles and
the rate for those miles. it is done in alphabetical order. when i need to
add a row, how do iget the formula to apply to that row like the others.

Reply to this Message

Niek Otten - 07 Mar 2008 22:35 GMT

Tools>Options>Edit tab, check Extend data range formats and formulas
Read HELP to make sure how it works

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|i have a spreadsheet in excel 2003 that i use to figure trucking miles and
| the rate for those miles. it is done in alphabetical order. when i need to
| add a row, how do iget the formula to apply to that row like the others.

Reply to this Message

Gord Dibben - 07 Mar 2008 22:38 GMT

Where is the formula located and what does it look like?

You can enter a formula at the top of the sheet like =SUM(A:A) entered in B1

You can enter a formula at the bottom of the data range.

=SUM(A2:INDEX(A:A,ROW()-1)) entered in A12

As you insert rows above row 12, the formula will include those rows.

If you also want the formulas inserted with the row see David McRitchie's site
for his INSERTROW event code.

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

Gord Dibben MS Excel MVP

>i have a spreadsheet in excel 2003 that i use to figure trucking miles and
>the rate for those miles. it is done in alphabetical order. when i need to
>add a row, how do iget the formula to apply to that row like the others.

Reply to this Message