Using the Autofill formulas feature in Microsoft Excel for calculations
Once you have created a formula to do your calculations in Microsoft Excel for one item in a data, you can use the autofill feature to complete all the calculations quickly without having to rewrite the formula in every relevant Excel cell.
How to implement an 'autofill' in Excel:
Click on the Excel cell.
Take your mouse to the right bottom corner of the Excel cell where you can observe a square black handle.
Now drag with the mouse when you see a thin dark cross.
The data in the lower Excel cells is automatically calculated as shown in the Excel training video below.