Excel – Switch Between Relative, Absolute, and Mixed References

Microsoft Excel Tips and Tricks

Excel has three cell references – Relative, Absolute, and Mixed. It is critical to understand when to use each reference in Excel. The default reference is relative is used frequently in Excel. The next highly used reference is absolute. Finally we have two mixed reference.

Credit Chris Menard