Hi,
I've got a spreadsheet with a lot of columns, each with VERY LONG formulas in them and a lot of conditional formatting. Once the spreadsheet is full of data I may need to insert rows in the middle of it from time to time. When I do this however, Excel only inserts blank cells - it doesn't insert the formulas. Is there an way of getting Excel to insert the formulas into the new cells (other than just highlighting the row above and copying the formulas down - I want to avoid this if possible to make using the sheet more user friendly)?
Cheers,
Chris
Bookmarks