Is there a way to insert columns and/or rows into an existing spreadsheet and have the formulas automatically adjust and not ruin all of the hard work? It would seem possible and terrible to have to adjust each and every formula.

Thanks in advance.


(Excel 2007)