Excel Guides

Relative Worksheet References in Excel

When working with formulas in Excel, you may want to reference a cell in a worksheet other than the one you are currently working in. For example, if you have a formula in cell A1 of Sheet1 that needs to reference cell B2 of Sheet2, you can do so by using a relative worksheet reference. Relative references are based on the position of the cell being referenced, relative to the position of the cell containing the formula.

To create a relative worksheet reference, simply type the name of the other sheet followed by an exclamation point (!). For example, to reference cell B2 on Sheet2 from cell A1 on Sheet1, you would use the following formula:

=Sheet2!B2

If you then copy or move this formula to another cell, the reference will be automatically updated to reflect the new location. For example, if you copy the formula from cell A1 to cell A2, the new formula will reference Sheet2!B3 (one row down and one column over from the original cell).

You can also use relative references when referencing cells on the same sheet. For example, if you have a formula in cell A1 that needs to reference cell B2, you can use a relative reference like this:

=B2

If you then copy or move this formula to another cell, the reference will be automatically updated to reflect the new location. For example, if you copy the formula from cell A1 to cell B1, the new formula will reference C2 (one row down and one column over from the original cell).

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.