To change the type of cell reference: Select the cell that contains the formula. In the formula bar , select the reference that you want to change. Press F4 to switch between the reference types. The table …

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

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

Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.

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 …

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells.

How to use the INDEX function in Excel to return a value or reference to a value within a table or range.

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 references.

The following list describes the text values that the CELL function returns when the Info_type argument is "format" and the reference argument is a cell that is formatted with a built-in number format.

How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.