RaulDR

Let say I have a formula in cell E1 =sum(A11) and another formula in cell E2 =sum(A22) if I insert a row between the two formula I want excel to automatically copy the formula in the inserted row

### Re: Visual Studio Tools for Office auto copy of formula

Albert Raiani

When you insert a new row Excel doesn't automaticaly copy the formula down. However, after you insert the new row(s) you can just highlight cells E1, E2 and E3 and press ctrl+d to copy the formula down.

Al

RaulDR

thanks Al!