Home > Microsoft Office > Excel > Apply Formula - Excel

Apply Formula - Excel
If you want to apply a formula down a large amount of rows, there is an easier way than having to copy and paste the formula hundreds of times. Here's how to apply a formula down many rows in just one click. This article shows Excel 2016, but this process also works in Excel 2013 & 2010.

Step 1:Open or create the data in Excel. Designate a column for your formula.

Step 2:Enter your formula in the first row of the formula column under the column label.

Step 3:Hover over the bottom right corner of the cell containing the formula. The pointer will turn into a +.

Step 4:Double click while the pointer is a +, and the formula will be applied down all of the adjacent rows. 

Related Articles