98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Referencing between worksheets
Referencing between worksheets
Resolved · Low Priority · Version 2007
Alaisdair has attended:
Excel Introduction course
Excel Intermediate course
Referencing between worksheets
How do you cross reference a cell from one sheet on a spreadsheet to another sheet on a spreadsheet.
RE: Referencing between worksheets
Hi Alasdair,
Thank you for your post, in order to do this I would probably use the Watch Window;
1. Go to the Ribbon and select the Formulas tab.
2. In the Formula Auditing section, select Watch Window.
3. The Watch Window will appear.
4. Click the Add Watch button to specify the cell you wish to monitor.
You can now monitor the value of the selected cell while continuing to work on any area of the workbook. You can also double-click on the cell in the Watch Window to quickly go to that cell.
I Hope that helps, regards Pete
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. |
Excel tip:Finding your worksheets quicklyThe arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook. |