For one way, take a look he

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

In article ,
Johnny G wrote:

I have a hidden column with a similar formula in each cell. For example cell
B2 is "=month(A2)", B3 is "=month(A3), etc. There are time when a row has to
be inserted, and since the B column is hidden from the end user I would like
to automatically add the formula to the cell added in the B column. Hope that
is easy to follow ;)