In my experience users have a harder time with row insert that they do with
copying a formula. If they can insert a row, they can typically copy the
formula with the fill handle.
However, if this is beyond your users, you would need a macro to do what you
want. Or, eliminate the column completely, and use the row numbers Excel