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

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 …

Select the range of cells that contains formulas in which you want to replace cell references with defined names. Select a single, empty cell to change the references to names in all formulas …

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 …

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

The cell range listed in the table_array argument can use relative or absolute cell references. If you're going to copy your function, you need to use absolute references, like this:

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 …

A name is a meaningful shorthand that makes it easier to understand the purpose of a cell reference, constant, formula, or table, each of which may be difficult to understand at first …

You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS (2,3) returns $C$2.

Gunakan referensi sel absolut atau relatif dalam rumus, atau campuran keduanya.