Insert a row, keep the formulae

[JamesFletcher]

Hi all,

Is there a way for me to insert a new row into a work sheet and have it copy the formulae that were there before?
It's similar to the way Excel keep the formatting of the row above, I want to keep the formulae of the cells above. If there's a way without using macros, that would be even better!

I have attached an example sheet. I will need to insert rows on row 31, 40, 48, and 55.

Thanks a lot

[VKS]

Hello James, There may be better solutions, in my opinion the easiest one is to convert the range into a table and when you insert a line it will pickup the formula on its own. Best Regards/VKS

[JamesFletcher]

I would do that but I need to do insert for the entire row and creating tables would mean a lot of work to insert every line.