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 » excel training course - Linking data
excel training course - Linking data
Resolved · Low Priority · Version Standard
Tim has attended:
Excel Intermediate course
Linking data
what is the best way to link data between work sheets?
RE: Linking data
Hi Tim,
Thanks for the question
THe best way to link worksheets is to press the equals sign (=) and navigate to the other worksheet and click on the cell with the data in it. Thereby creating a link between the sheets. If you then went into the sheet that you have put the link in it will ask you whether you want to updata or not update the link.
I hope that helps
Tracy
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! |