formula accross cells..when inserting a row..

M

mike_mike

Hi

When a user insert a row how do i get excel to automatically set a formula
in the cell.
For example "spreadsheet" with 3 rows..
1
2
3

when i insert a row
i want
1
2
3
4
not
1
2

3
thanks
mike
 
Top