When the cells are not visible on the worksheet, you can view the value and its formula in the watch window. It helps to inspect, audit or confirm the formula in the cell.

-- When cells are not visible on a worksheet, you can watch those cells and their formulas in the Watch Window toolbar.

-- The Watch Window makes it convenient to inspect, audit, or confirm formula calculations and results in large worksheets.

-- By using the Watch Window, you don't need to repeatedly scroll or go to different parts of your worksheet.