How to Import an Excel Spreadsheet into Another Sheet

Linking
1. Launch Microsoft Excel and open the source file that contains the data to be linked.
2. Open or create the destination file in which the data will be displayed.
3. Navigate to the source spreadsheet and highlight (or 'Select') the cell or range of cells to be imported by clicking the cell, or clicking the top left corner of the range of cells and holding the mouse button down while dragging the cursor to the lower right corner of the range of cells and then releasing the mouse button. Alternately, click the gray button that contains the row number or column letter to select an entire row or column, respectively, or click the gray button in the upper left corner of the spreadsheet between the row header '1' and the column header 'A' to select the entire sheet.
4. Right-click any cell in the selected range of cells and click 'Copy.'
5. Navigate to the destination spreadsheet where the data will reside and click once on a cell that you want to make the upper right corner of the copied data from the source spreadsheet. If an entire row or column was selected, click the first cell in the row or column or select the row or column by clicking the gray box that contains the number or letter of the row or column. If you selected an entire spreadsheet click the cell 'A1' or the gray button in the upper left corner of the spreadsheet between the row header '1' and the column header 'A.'
6. Right-click in the selected cell or header.
7. Select 'Paste' to copy the contents of the original cells exactly as they are to the new location, with no links back to the original data. This will allow a duplicate spreadsheet to be created including data and formulas, but subsequent changes to the original spreadsheet data will not be reflected in the new location. Formatting will be copied with this method.
8. Select 'Values' to copy the current values stored in each cell to the new location. This will not copy any formulas, but will copy the current results of any calculations performed by any formulas. Subsequent changes to the original spreadsheet data will not be reflected in the new location. Formatting will not be copied with this method.
9. Select 'Formulas' to copy all the existing formulas and values to the new location. Subsequent changes to the original spreadsheet data will not be reflected in the new location. Formatting will not be copied with this method.
10. Select 'Transpose' to copy the data and formulas along with the formatting to the new location in a transposed orientation, so that rows become columns and columns become rows. Subsequent changes to the original spreadsheet data will not be reflected in the new location.
11. Select 'Formatting' to copy the formatting of the selected cells but leave the cells empty. No values or formulas will be copied, but format attributes such as cell color and currency formatting will be reproduced.
12. Select 'Paste Link' to create a link to the source spreadsheet that will be updated when the original spreadsheet data is updated. This will allow the data from the original spreadsheet to be shown in the destination spreadsheet without allowing any changes to be made to the original spreadsheet from within the destination spreadsheet.