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 » Links
Links
Resolved · Low Priority · Version 2003
Jane has attended:
Excel Introduction course
Links
how do you link one cell in a different worksheet to another cell but in the same work book
RE: links
Hi Jane,
Thank you for your post, welcome to the forum,
You can link cells from different worksheets by using the = (equals) key.
In the destination worksheet select the cell you wish to link and press the = key; navigate to your source worksheet and select the cell to be linked, press Enter and you will be returned to the destination cell with the information inserted, if you check the formula bar you will see the linking script. I hope that has helped, 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:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |