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 london - Linking Worksheets
excel london - Linking Worksheets
Resolved · Low Priority · Version Standard
Mon 5 Feb 2007, 14:04Delegate Sarahjane said...
Sarahjane has attended:
Excel Intermediate course
Linking Worksheets
How do you link worksheets? Once you have opened 2 worksheets are they automatically linked or is there a formula that needs to be used?
Tue 6 Feb 2007, 09:46Trainer Richard said...
RE: Linking Worksheets
Worksheets are not automatically linked.
To add cells on different sheets you would use the formula:
=A1+Sheet2!B1
Where "Sheet2" is the name of the worksheet
Separated with a !
Simply create the formual like you normall would, but click on the relevant sheets and cells as you create the formula.
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:How to Spell Check an Excel 2010 WorksheetExcel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet. |
