Back to Excel Formulas menu

The usage of the fill handle with formulas


In many occasions there is a need to copy a formula over and over again, with a slight accommodation to it.
For instance, let’s assume you have the following list in the worksheet:

An example for the usage of Excel fill handle

If you want to fill column C with the formula that will multiply the list by 10, you have two ways of doing it:

Doing it manually:
You can type in cell C3 the formula:
=B3*10
Then type in cell C4 the formula:
=B4*10
Then type in cell C5 the formula:
=B5*10
…and so on until you’ve finished with the list.
(not practical for long lists)

Another way: Using the fill handle
Type once the formula in cell C3:
=B3*10
Now hit the “Enter” key and select cell C3 again.
Pull downwards the fill handle (the small square at the lower left corner of the active cell), and you have immediately the whole list filled with the correct formulas.
Small tip: instead of pulling the fill handle, try double clicking it.