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 » excel training courses - Workbooks
excel training courses - Workbooks
Resolved · Low Priority · Version Standard
Tue 3 Jul 2007, 12:50Delegate Veronique said...
Veronique has attended:
Excel Intermediate course
Workbooks
Hi,
How do I link workbooks?
Thanks,
Veronique
Tue 3 Jul 2007, 16:16Trainer Amanda said...
RE: workbooks
Hi Veronique
Thank you for your question.
You can link one cell in one file to another cell in a different file by:
Opening both files
Choosing the cell that you want the linked result to appear in
Press =
Go to the other file and clicking on the cell you want to link to
Press Enter.
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:Use the Ctrl-key for quick navigation in Excel 2010If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key. |
