This video explains how the dollar sign is used in Excel formulas to control whether cell references stay fixed or change ...
Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.