From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Copying a formula into adjacent cells

Copying a formula into adjacent cells

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Copying a formula into adjacent cells

“

- We're looking at a worksheet called CopyFormulas, in the workbook, 03 - Creating Formulas and Functions. A formula is written in cell B4. Remember, if the cell is selected, you can see the formula in the formula bar, or if you've zoomed in, as this particular worksheet has been, you can double click here, perhaps see it a little bit better, and it is color coded. Now, we need to do this for February, March, April, May, June. Possibly in a similar worksheet, we might have 12 months here. We don't want to be retyping this kind of a formula many, many more times. In Excel, it's not uncommon that after you've written a formula, you need to copy it either rightward into adjacent cells, or downward. And it's a huge time saver to be able to do this. Now, the formula that we're seeing here, and I'll double click it again, is B2-B3. We certainly do not want to see that formula right here. But when you copy a formula, Excel does what we would want it to do. In other words, and if we think of…

Contents