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

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.

Use absolute references for range_lookup. Using absolute references allows you to fill-down a formula so that it always looks at the same exact lookup range. Learn how to use absolute cell …

By default, new formulas use relative references, so you may need to switch them to absolute references. For example, if you copy or fill an absolute reference in cell B2 to cell B3, it stays …

The cell references may have changed based on the reference type (absolute, relative, or mixed) used in the formula. For example, if you copy a formula in cell A1 and paste it two cells down …

Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER. Note: Using $ symbols tells Excel that the reference to B2 is "absolute," which means that when you …

In one or several formulas, you can use a cell reference to refer to: Data from one or more contiguous cells on the worksheet. Data contained in different areas of a worksheet. Data on …

Change a cell reference from relative (default) to absolute to maintain the original cell reference when you copy it. Maintain cell reference by putting a dollar sign ($) before the cell and column …

When you create a simple formula or a formula by that uses a function, you can refer to data in worksheet cells by including cell references in the formula arguments. For example, when you …

When you use explicit cell references like this (where you reference each cell individually, separated by a comma) and delete a referenced row or column, Excel can't resolve it, so it …

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: …