If you want to maintain the original cell reference in this example when you copy it, you make the cell reference absolute by preceding the columns (B and C) and row (2) with a dollar sign ($). Then, …

If you want to maintain the original cell reference when you copy it, you "lock" it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 …

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 …

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

A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. Use a 3-D reference to consolidate data in different worksheets.

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 …

The FIXED function rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.

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

When you use explicit cell references like this (where you reference each cell individually, separated by a comma) and delete a referenced row or column, Excel can't resolve it, so it returns the #REF! error.

Multiply a column of numbers by one number in another cell by using an absolute reference to the number you want to multiply by, which means that the $ symbol is inserted into the number: for …