FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same. Place a “$” before a row number if you want that to always stay the same.

Detailed explanation-2: -Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row.

Detailed explanation-3: -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 from C2 to D2, the formula stays exactly the same. This is an absolute reference.

Detailed explanation-4: -An absolute reference in Excel is a reference that cannot be changed when copied, so you won’t see changes in rows or columns when you copy them. Absolute references are used when you want to fix a cell location. These cell references are preceded by a dollar sign.

Detailed explanation-5: -Copying a formula: When you copy a formula, relative cell references will change.