Watch a formula and its result by using the Watch Window
To select all cells on a worksheet with formulas, on the Home tab, in the Editing group, click Find & Replace, click Go To Special, and then click Formulas. On the Formulas tab, in the Formula Auditing group, click Watch Window. Click Add Watch . Click Add. Move the Watch Window toolbar to the top, bottom, left, or right side of the window.