If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
inserting rows where a formula is inuse for that column
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. |
#2
|
|||
|
|||
inserting rows where a formula is inuse for that column
ToolsOptionsEdit tab, check Extend data range formats and formulas
Read HELP to make sure how it works -- Kind regards, Niek Otten Microsoft MVP - Excel "Rose" wrote in message ... |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. |
#3
|
|||
|
|||
inserting rows where a formula is inuse for that column
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 On Fri, 7 Mar 2008 13:14:08 -0800, Rose wrote: 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. |
Thread Tools | |
Display Modes | |
|
|