The Autofill feature of Excel can be applied on formulas as well as predefined lists. Let us take a simple example:
Suppose you have two columns of Quantity and Price and you want to derive a third column of Value by multiplying the quantity by the Price, then you:
- Enter the formula in the first row of data as follows:
- Drag the fill handle
across the rest of the rows to generate the formulas.
- Your data will now look like this.
