The best way that I’ve found to fix a spreadsheet is to kill the spreadsheet. What I mean by this is to use spreadsheets more as a quick and easy way to format a fancy table and less of an end product. Granted, if you need to constantly update numbers in a sheet full of formulas, you’ll need to keep the spreadsheet.