Excel Reference Another Worksheet. Web can formulas reference a duplicate spreadsheet with different names. Create a cell reference to another worksheet.
Data contained in different areas of a worksheet. In your destination file, click on the cell you wish to add your reference to and type =. Press the equal sign, and then click on the.