How to Cross Reference Between Excel Spreadsheets

1. Launch Microsoft Excel and open the spreadsheet that is going to display information contained in other files.
2. Open each of the other files that has information you want to reference in the display spreadsheet.
3. Switch back to the display spreadsheet and click once in the cell that is going to display information from another spreadsheet.
4. Press the 'Equal' ('=') key on the keyboard and immediately switch to the spreadsheet that contains the first piece of information that needs to be displayed.
5. Click the cell that contains the information that will be displayed in the display spreadsheet and press 'Enter.' The display spreadsheet now contains a reference to the information contained in the other spreadsheet, and this information will automatically update when changes are made to the data.