You know, I’m pretty confident in my use of Google Sheets. I use a lot of it’s advanced features and formulas in my daily work.
But one thing was bugging me. Every time I created a formula and then grabbed and dragged (or double clicked) that little box in the bottom right of the cell to have it repeat, the cells would change.
This normally is great, because it moves by a cell each time and makes my life easier.
What if I want to keep a certain cell constant in a formula?
Enter the Absolute Reference.