I am trying to create a formula so when you add a new line, it drags the copied formula in one column but not the others. For example, I want the 50 to stay constant each time I create a new row below it but not any of the other data. What is a formula that will do this? Thank you!
MacBook Pro, iOS 10.1.1
in the cell below the cell with a red background (let's say the red cell is B9), enter the formula
=B9
then select the cell where you just entered the formula (the cell just below the red cell) and copy. Now select the cell just be low the red cell all the way to the end of the same column paste
Okay, that works. Is there not a way to do this though when you just add a new row to enter other data it automatically populates the cell in that same column?
Number does not repeat entered data but will repeat formulas
Formula Help
