You want to apply the same formula to an entire column of numbers in Excel. We’ll show you how it’s done.
Automatically apply Excel formulas to the entire column
© PixieMe / Shutterstock.com
One often uses formulas in Excel for an entire column, for example to multiply previous values or to do other calculations. But how can a formula that you enter in a single cell be applied to the rest of the column? We’ll show you the solution and reveal one
saved a lot of work
Apply Excel formulas to the entire column
If you want to apply the same formula to an entire column of numbers, do the following:
It’s even faster with this trick
If the columns are very long, pulling boxes by hand can be cumbersome and require a lot of scrolling.
Here comes the insider tip
: Enter the formula as described and then double-click the fill-out box – it must be a
appear to make it work. Excel then automatically adopts the formula for all cells with a numerical value in the neighboring cell on the left.
Double-clicking on the fill-out box copies the formula in C2 into the cells of column C. The fill-out box is the corner of the cell marked in red here.
Solve 10 common problems in Excel
There are even more Excel articles here: