Below are the steps to automatically create a reference to another sheet: Select the cell in the current workbook where you need the reference Type the formula till you need the reference (or an equal-to sign if you just want the reference) Select the sheet to which you need to refer to Select the cell/range that you want to refer to

To reference cells in another sheet, here’s what to do: Select the cell where you want the reference. Type an equal sign (=) into the formula bar. Go to the sheet with your data and click on the cell range you need. Press Enter and the reference will show in the cell.

To refer to a cell or a range of cells in another worksheet, type the name of the target worksheet followed by an exclamation point (!) before the cell or range address. For example, here's how you can refer to cell A1 on Sheet2 in the same workbook: =Sheet2!A1

Using a cell reference in a formula with the worksheet name helps specify the location of the data in a different sheet. For example, =Sheet2!A1 refers to cell A1 in the Sheet2 worksheet. This ensures accurate referencing across multiple sheets, enhancing organization and linking data between different parts of your Excel workbook.