Excel Reference Another Worksheet

Excel Reference Another Worksheet. Web can formulas reference a duplicate spreadsheet with different names. Create a cell reference to another worksheet.

How Do I Reference a Cell in Another Worksheet in Excel?
How Do I Reference a Cell in Another Worksheet in Excel? from www.ehow.com

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.