If you don’t know why you would want to add dollar signs to a formula, then I would recommend reading that post. If you do, read on for a simple, but often missed, tip for adding them quickly.
When entering a reference in a formula, there are four possible ways in which you can apply the dollar signs:
1. Fix both the column and the row, e.g. =$A$1
2. Fix just the row, e.g. =A$1
3. Fix just the columns, e,g. =$A1
4. Fix neither the column, nor the row, e.g. =A1
This can be quite fiddly, typing the dollars in the right place, particularly if you have entered the reference by clicking the cell and then need to click the cursor in the right place to enter the dollar sign(s).
This is where this simple tip comes in.
As long as the cursor is in the reference, or immediately before or after it, you can use the function key F4, to toggle through the options above (in the order shown).
That’s it, pressing F4 once adds both dollars, twice fixes the row, three times fixes the column, four times removes the dollars again. If you got over-excited and missed the right one, you can keep cycling through the options until you hit it again.
Simple, I know – but again, only if you already know it!