Forum home » Delegate support and help forum » Microsoft Excel Training and help » General
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
General
Resolved · Low Priority · Version 2007
Reply Wed 7 Dec 2011, 16:23Delegate Claire said...
Claire has attended:
Excel Intermediate course
General
What is the watch menu you mentioned during the course?
For upcoming training course dates see: Pricing & availability
RE: 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
Wed 14 Dec 2011: Automatically marked as resolved.
|