How To Copy A Formula Into Adjacent Cells in Excel

How To Copy A Formula Into Adjacent Cells in Excel (Video transcript)

In the last lecture, we created a simple formula here, to get the quarter 1 total, the company total, and the average of the quarters.

we want to do the same for the other quarters and the company. we can use our previous formula. double click it to see it and the related cells.

we don’t need to write here another formula. we can drag it here and across all the quarters. Excel automatically changes the cell reference to copy the formula. if we double click here we can see the change.

In the same manner we can drag it down to get the total and the average for each company. all formulas are copied. It is a super easy task for excel.

Add Comment