TIP - 55 : Watch window - to know changes on your sheet tab

Watch window - to know changes on your sheet tab

This will be used to observe any particular cell or range of cells –

One way is to see the result of a formula of cell which can be observed from watch window, no need to move around the worksheet.

Second way is we can use this as a selecting and moving to the required cell from watch window.

Step 1: Please click on Watch window from Formula tab

Step 2: From the dialogue box “Watch Window”, click on Add watch and select the cells or range, then finally click on Add (based on your requirement)

So that we can watch the result or move through via watch window, which can also be added to your screen at formula bar (whenever is required click on watch window)