links

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Links

Links

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Sorting List Subtotals

If 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.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips


Server loaded in 0.08 secs.