excel london - linking worksheets

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel london - Linking Worksheets

excel london - Linking Worksheets

resolvedResolved · Low Priority · Version Standard

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?

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 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:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips


Server loaded in 0.41 secs.