Use absolute or relative cell references in formulas, or a mix of both.

To include structured references in your formula, select the table cells you want to reference instead of typing their cell reference in the formula. Let's use the following example data to enter a formula that …

Absolute references An absolute cell reference in a formula, such as $A$1, always refer to a cell in a specific location. If the position of the cell that contains the formula changes, the absolute reference …

Multiply a column of numbers by one number in another cell by using an absolute reference to the number you want to multiply by, which means that the $ symbol is inserted into the number: for …

After you paste a copied formula, you should verify that all cell references are correct in the new location. The cell references may have changed based on the reference type (absolute, relative, or …

Select the range of cells that contains formulas in which you want to replace cell references with defined names. Select a single, empty cell to change the references to names in all formulas on the worksheet.

Instead of entering values, you can refer to data in worksheet cells by including cell references in formulas.

The cell range listed in the table_array argument can use relative or absolute cell references. If you're going to copy your function, you need to use absolute references, like this:

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

If you want to maintain the original cell reference when you copy it, you "lock" it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 …

You can refer to the contents of cells in another workbook by creating an external reference formula. An external reference (also called a link) is a reference to a cell or range on a worksheet in another …