98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Low Priority · Version 2007
Mon 9 Jun 2008, 16:34Delegate Rachel said...
Rachel has attended:
Excel Introduction course
Excel Intermediate course
Formulas
How do i link formulas in one sheet to other formulas in another sheet?
Wed 11 Jun 2008, 15:07Trainer Amanda said...
RE: Formulas
Hi Rachel
Thank you for your question.
There are two ways of linking cells between sheets.
1. Select a cell in the sheet you wish to create the link in; then type in = and select the cell in the other sheet you want to link to. Press Enter.
2. Select the cell you wish to create a link to and copy it. Go to the cell you wish to create the link in, then go to Edit - Paste Special and click the Paste Link button.
I hope this helps.
Amanda
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:Switch on smart tags – Excel 2007In order to use smart tags, make sure they are turned on, to do this: |
