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 » Cell referencing
Cell referencing
Resolved · Low Priority · Version 2003
Barry has attended:
Excel Introduction course
Cell referencing
How do I use a cell reference from a different sheet
RE: cell referencing
Hi Barry,
Thank you for your question.
Click into the cell where the formula will be and click =.
Switch to the other sheet and select the cell required, then add the required operator (multiply, addition, subtract or divide).
Then switch back to the sheet where the formula was created and continue to add the cell from that sheet and press enter to end the formula.
I hope this answers your question.
Regards
Simon
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:Viewing two Excel 2010 Workbooks at the same timeDid you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth! |