Forum Discussion
Solved
Stop Autofill from Incrementing Certain Cells
I am going to try to explain this the best I can. Please, be patient with me. It might take a few attempts when it comes to properly describing things. Thanks! I am making a spreadsheet that keeps t...
Let's say the date of birth is in B2 and down. In the formulas to the right, refer to $B2 instead of just B2.
The $ before the column letter B makes the column reference absolute, i.e. fixed.
Because there is no $ before the row number 2, the row reference is relative, i.e. it changes when you fill down.
More information and examples are available in this article: Why use $ in Excel formula: relative & absolute cell reference (And mixed cell references used a fixed column and a varying row, or a varying column and a fixed row.)