Create a cell reference. Cell references can refer to cells on the same worksheet, a different worksheet, or a different workbook.

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 …

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

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.

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.

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

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

It's important to be aware of the possibilities for how a relative cell reference might change when you move or copy a formula. Moving a formula: When you move a formula, the cell references within the …

Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. There are four different types of calculation operators: …