|
There is a function in Excel called auto complete. When you click on a cell, there is a small black square in the lower right corner. Put your cursor on that square and drag it down the column. It should copy the formula for you and adjust the cell references for that row.
|