How to Format Relative References in Excel. ... For example, "=Sheet2!A1:B5" references a range of 10 cells on "Sheet2." Sheet names are located on tabs near the bottom of the Excel window.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you ...

Toggling Between Reference Types in Formulas . There are three types of references in Excel—relative references, absolute references, and mixed references—and you can use the F4 key to toggle ...