excel software training - Linking spreadsheets

Hi Jonas

Thanks for your question.

You can link two spreadsheet together in one of two ways:

1. Copy the data from the source spreadsheet (the spreadsheet supplying the data), open the destination spreadsheet (the spreadsheet that will contain the link) then go to Edit - Paste special and select the Link option, click OK.

2. In the destination spreadsheet, start a formula by typing = into a cell then go to the source spreadsheet and click on the cell you want to link to, and press Enter.

Amanda