Auto Insert/Auto Formula?
 

Is there a way that when you insert a row, a formula (or series of
formulas)from the row above is automatically inherited?


--
Abacus
------------------------------------------------------------------------
Abacus's Profile: http://www.excelforum.com/member.php...o&userid=31114
View this thread: http://www.excelforum.com/showthread...hreadid=507805

Auto Insert/Auto Formula?
 

I don't know how to do it in a single step. In two steps,
after inserting the row, highlight the the target row
range and press CTRL d.
--
Robert


"Abacus" wrote:


Is there a way that when you insert a row, a formula (or series of
formulas)from the row above is automatically inherited?


--
Abacus
------------------------------------------------------------------------
Abacus's Profile: http://www.excelforum.com/member.php...o&userid=31114
View this thread: http://www.excelforum.com/showthread...hreadid=507805