Question

What is the difference between relative and absolute reference?​

Answer 1

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

${\green{━━━━━━━━━━━━}}{\purple{\bold{\:♡\:}}}{\green{━━━━━━━━━━━━}}$

$\: \: \: \: \: \: \: \: \: \: \: \large \underline{ \sf \color{indigo}{Relative \: references }}$

By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2. Relative references are especially convenient whenever you need to repeat the same calculation across multiple rows or columns.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

$\: \: \: \: \: \: \: \: \large \underline{ \sf \color{indigo}{Absolute \: references}}$

There may be times when you do not want a cell reference to change when filling cells. 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. If it precedes the column or row (but not both), it's known as a mixed reference.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━