You know, I’m pretty confident in my use of Google Sheets. I use a lot of its 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.