Press Alt > W > E > F in sequence (not all at once). This sequence activates the View tab and toggles the Focus Cell. Remembering this shortcut lets you treat the feature as a temporary reading ruler.
This video explains how the dollar sign is used in Excel formulas to control whether cell references stay fixed or change ...
With Endex, you can build a full DCF in Excel, including history, projections, and valuation outputs, producing audit ready ...