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

If you are creating a reference in a single cell, press Enter. If you are creating a reference in an array formula (such A1:G4), press Ctrl+Shift+Enter. The reference can be a single cell or a …

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

Do one of the following, select the cell that contains the value you want or type its cell reference. You can refer to a single cell, a range of cells, a location in another worksheet, or a location 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 …

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.

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

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 …

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

To use the operators, such as less than (<) and greater than (>), the operator must be concatenated with the formula. For example, to specify a match of greater than the value in …