General

Hi Claire,

Thank you for your question and welcome to the forum.

The Watch window is found on the Formulas Tab. If your worksheets are linked via a formula, you. If you create a link in Cell A1 on sheet2 to cell A1 on Sheet1, then when you make a change to cell a1 on Sheet1, the value in cell A1 on Sheet2 changes automatically.

Click on the Watch window and select Add Watch. As you make a change to cell A1 on Sheet1, you want to see the impact on Cell A1 of Sheet2 without switching sheets.

1. Click Add Watch.
2. Select Sheet2 and click cell A1.
3. Click Add.
4. The cell appears in the list along with the formula and value.

I hope this answers your question.

Regards

Simon