From the course: Excel 2013 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 for adjacent cells

Copying a formula for adjacent cells - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Copying a formula for adjacent cells

“

In this worksheet CopyFormulas, in the workbook 03-Creating Formulas and Functions, we've got a formula in cell B4 and we need to have that same kind of formula in cell C4, D4, all the way over into G4. Now, if we talk about copying a formula, you might say, "well, we don't want this exact formula to be copied into column C, because we would get the same answer, we get a 20". In column C we want to subtract these two cells. Many, many times when you've written a formula in Excel, you need to copy it across a row into adjacent cells or in some cases down a column. What we would like to see here of course is the answer 30 and the answer 50 over here and so on. We need to copy a formula. Fortunately, the way that Excel copies formulas is that it really copies the relationship and that's an unusual way of saying it, but in this formula right here, a different way of phrasing it is, this formula subtracts the two cells above it--top cell minus the cell below it. Do we want to do same thing…

Contents