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.
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.