Module-2 Chapter 13: Absolute & Relative Reference

In Excel, absolute and relative references are used to tell Excel how to treat cell addresses when a formula is copied to another cell.
Relative references change when a formula is copied to another cell. By default, all cell references are relative. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will adjust to =A2+B2.
Absolute references, on the other hand, do not change when copied. They are fixed references to a specific cell. You can make a cell reference absolute by adding a dollar sign ($) before the column letter and row number. For example, $A$1 is an absolute reference to cell A1.
There’s also a mixed reference, where one part of the reference is absolute and the other is relative. For instance, $A1 is an absolute reference to column A but a relative reference to row 1.

[@riyaznadwi0607]

Wow the new thing I learnt is putting absolute reference formula

[@TechMe.79]

Check out the custom list in chapter 12. That is also a very handy thing. If you make custom list of your own, you will save lot of time in future.