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?

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
>
>