Switch between relative, absolute, and mixed references
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. …
Create or change a cell reference - Microsoft Support
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 …
Use cell references in a formula - Microsoft Support
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 …
Switch between relative and absolute references - Microsoft Support
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 …
Using structured references with Excel tables - Microsoft Support
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 …
Create workbook links - Microsoft Support
You can refer to the contents of cells in another workbook by creating an external reference formula. An external reference (also called a link) is a reference to a cell or range on a …
Create a 3-D reference to the same cell range on multiple …
Use a 3-D reference in Excel to reference several worksheets, such as when you consolidate budget data from different departments in your organization.
INDIRECT function - Microsoft Support
How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.
Lookup and reference functions (reference) - Microsoft Support
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.
Move or copy a formula in Excel - Microsoft Support
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 combinations. The table summarizes how a reference …