From the course: Learning Excel 2016

Unlock the full course today

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

Understanding cell references when copying and pasting

Understanding cell references when copying and pasting

From the course: Learning Excel 2016

Start my 1-month free trial

Understanding cell references when copying and pasting

“

- Quite often, when we add a formula or a function as we did in the previous movie, it's going to refer to a certain range of cells and odds are pretty good that it could be used for other ranges of cells, which is the case for our Landon Hotels Revenue sheet. You can open up RH_Revenues0105 if you need to get caught up. Here we entered our formula in cell C11 for our January figures. But we can use that same formula for February and March as well. Now if we wanted to, we could fill in those formulas or functions by typing them out just as we did for the original. But what's really cool about Microsoft Excel is it uses relative cell addressing. That means if we copy the formula here in cell C11 to D11, it knows to use the numbers in column D. And if we copy it to column E, it knows to use the numbers in column E. That is relative cell addressing. And if we wanted to, we could go to the cell, go up to our Home tab here and use Copy and Paste if we wanted to. But there's an even faster…

Contents