Join David Rivers for an in-depth discussion in this video Understanding cell references when copying and pasting, part of Office 365: Learning Excel.
- 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 way.…You may have noticed that, the cell…
- What is Excel?
- Creating and saving workbooks
- Adding formulas and functions
- Using AutoFill
- Formatting, text, numbers, dates, and times
- Merging cells
- Inserting charts and pictures
- Sharing and printing workbooks
Skill Level Beginner
Q: This course was updated on 04/24/2017. What changed?
A: The following topic was updated: sharing workbooks using online options.