Tips and Tricks to Copy/Paste Formulas Down a Column
Excel provides an alternative method of referring to the cell in a specific column of the current row: by referring only to the column, leaving the row out of the reference. In the example above, change the for