Relative, Mixed and Absolute References
Absolute and Mixed references are a one of those dreaded features in Excel. It’s too bad because in only 30 minutes, you can set the record straight once and for all!
Understanding matters