Quote:
Originally Posted by healthpellets
is there a way to apply a function that i've written to every cell in a column without having to paste in it each cell and change the numbers based on the row?
|
You have three options; double-click the lower right-hand corner of the cell, click and drag the lower right-hand corner down as far as you want the formula to go, or copy the cell with the formula then highlight the range of cells you want that formula to be copied in and select paste (CTRL+V). Let us know if that doesn't work.