we applied a formula for some consequent rows, and inbetween we added some extra rows, then will the same formula will be applied automatically, if not tell the way how to get it done automatically
2007-12-10 22:42:30 · 4 answers · asked by suresh 1 in Computers & Internet ➔ Software
i dont want to copy it and i dont want to drag it. it should automatically come
2007-12-10 23:00:56 · update #1
You just need to copy the formulas in the above rows, simply copy paste or by dragging the auto fill.
2007-12-10 22:52:13 · answer #1 · answered by Cute Mama 3 · 0⤊ 0⤋
Highlight the last row above (with the formula in) and all the added rows, go to "Edit, fill down". It should copy the formula and change the cell references.
2007-12-10 23:33:27 · answer #2 · answered by Keith B 5 · 0⤊ 0⤋
if 2003 or better then just simply insert a row - right click on the row header where you want the new row - then in your formula you will see a little box , click on it and have the formula include adjacent cells - this will only work on simple calculations
2016-05-23 00:10:55 · answer #3 · answered by reva 3 · 0⤊ 0⤋
without 'doing anything' you will need to write a custom excel function using the 'visual basic for applications' programming language that excel uses for macros that will enter the formula when it senses a new row has been inserted since there is no feature of excel that will do this automatically for you.
2007-12-12 06:36:56 · answer #4 · answered by piquet 7 · 0⤊ 0⤋