Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.
With Endex, you can build a full DCF in Excel, including history, projections, and valuation outputs, producing audit ready ...