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 ($). …

You may need to select any cells that contain formulas and press F2 and then Enter to make the formulas work. You may also want to make the columns wider to make your worksheet easier …

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 …

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.

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 …

By default, new formulas use relative references, so you may need to switch them to absolute references. For example, if you copy or fill an absolute reference in cell B2 to cell B3, it stays …

Note: Using $ symbols tells Excel that the reference to C2 is "absolute," which means that when you copy the formula to another cell, the reference will always be to cell C2.

Enter numbers 1-10 in cells A2 to A11 and again in cells B1 to K1. Enter this formula in cell B2. The $ locks the value for the header row and the formula multiplies it by the value in the row. …

Instead of typing the constants into your formula, you can select the cells that contain the values that you want to use and enter the operators in between selecting cells.

For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box. This example uses the Abs …