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

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

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.

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.

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 …

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 …

Use a 3-D reference in Excel to reference several worksheets, such as when you consolidate budget data from different departments in your organization.

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 …