Saturday, March 25, 2017
MS EXCEL Linking of DATA
MS EXCEL Linking of DATA
Linking Data
Linking data between spreadsheets allows you to reference data contained elsewhere in your
workbook without having to copy all of the information. For example, you could have a workbook that has multiple spreadsheets tracking regional sales and a separate spreadsheet to tally the totals across all regions. By linking to the regional data from the totals, you will only have to update your
information in one location. The following explains how to link data between spreadsheets:
1. Open the spreadsheet that contains the source data and the target location (e.g. Ramesh Marksheet, Students Marksheet).
2. Select the cell(s) in the source spreadsheet that contain the data that you want to link to the
target location.
3. Right-click on the selected cells.
4. A context sensitive menu will appear. Click on Copy
Go to link download
Linking data between spreadsheets allows you to reference data contained elsewhere in your
workbook without having to copy all of the information. For example, you could have a workbook that has multiple spreadsheets tracking regional sales and a separate spreadsheet to tally the totals across all regions. By linking to the regional data from the totals, you will only have to update your
information in one location. The following explains how to link data between spreadsheets:
1. Open the spreadsheet that contains the source data and the target location (e.g. Ramesh Marksheet, Students Marksheet).
2. Select the cell(s) in the source spreadsheet that contain the data that you want to link to the
target location.
3. Right-click on the selected cells.
4. A context sensitive menu will appear. Click on Copy
Go to link download