Watch Window Function
Watch Window Function Here's your free trial of Copilot Pro Unlock now 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. This toolbar can be moved or docked like any other toolbar. For example, you can dock it on the bottom of the window. The toolbar keeps track of the following properties of a cell: workbook, sheet, name, cell, value, and formula. Note: You can only have one watch per cell. Add cells to the Watch Window Important: On a Mac, perform step 2 of this procedure before you perform step 1; that is, click Watch Window and then select the cells to watch. Select the cells that you want to watch. To select all cells on a worksheet with formulas, on the Home tab, in the Ed