Relative, Absolute, and Mixed References

In this lesson, we will learn cell reference logic in Excel. We will understand the difference between relative, absolute, and mixed references, why the $ sign is used, and how references change when formulas are copied. ## Lesson objective In this lesson, we will learn relative, absolute, and mixed references in Excel. In the previous lesson, we learned basic functions such as , , , , and . We learned how to write formulas, use ranges, and check formula results. One of the most important topics when writing formulas in Excel is cell reference logic. When a formula is copied from one cell to another, Excel may automatically change the references.