template-adding rows-include formula

I have a template with formulas but when you try to add rows, it
doesn't automatically add the formulas for that particular column.
How do I automate that to copy the formula when adding rows?

thanks

One way:

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

In article <[email protected]>,
"guideme" <[email protected]> wrote:

> I have a template with formulas but when you try to add rows, it
> doesn't automatically add the formulas for that particular column.
> How do I automate that to copy the formula when adding rows?
>
> thanks