Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+xp+training - How link a spreadsheet?

excel+xp+training - How link a spreadsheet?

ResolvedVersion Standard

Tue 10 Apr 2007, 13:38 Delegate Vicky said...

Vicky has attended:
Excel Intermediate course

How link a spreadsheet?

How do I link spreadsheets together

Wed 11 Apr 2007, 11:22 Trainer Tracy said...

RE: How link a spreadsheet?

Hi Vicky

Thanks for the question

To add cells on different sheets you would use a formula like:

=A1+Sheet2!B1

Where "Sheet2" is the name of the worksheet
Separated with a ! from the cell reference

Simply create the formual like you normally would, but click on the relevant sheets and cells as you create the formula

Hope that helps

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips

excel+xp+training - How link a spreadsheet?

How link a spreadsheet?

RE: How link a spreadsheet?

Excel articles

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet