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.

Author: karperc | Last Updated: 9/24/2018 11:20 AM | Page Views: 2018 |
helpdesk.etown.edu/helpconsole2012/KB/default.aspx?pageid=apply_formula
|