Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking spreadsheets

Linking spreadsheets

ResolvedVersion 2007

Fri 31 Oct 2008, 16:06 Delegate Simon said...

Simon has attended:
Excel Intermediate course
Excel Intermediate course

Linking spreadsheets

how do I link elements of different spreadsheets

Fri 7 Nov 2008, 09:22 Trainer Simon said...

RE: linking spreadsheets

Hi Simon,

Thank you for your question.

If you open both workbooks, click = in a cell and navigate and click on the cell in the other workbook that you need to be linked and press enter.

I hope this answers your question.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips

Linking spreadsheets

Linking spreadsheets

RE: linking spreadsheets

Excel articles

Excel tip:

Cycling through Absoulte cell references