Join David Rivers for an in-depth discussion in this video Understanding cell references when copying and pasting, part of Office 365 for Mac: Learning Excel.
- When you create a formula here in Excel,…the odds are pretty good that formula…could be used elsewhere in the worksheet.…And that is the case with our Landon Hotels…revenue sheet we've been building.…If you skipped to this movie, go to the Chapter One folder…and open up RH_Revenues0105, and you'll have what I have.…So here in cell C11, we used the Sum function…to total up this range of cells.…Well, we need to total up February and March as well,…so wouldn't it be nice if we could…copy and paste that formula to these cells?…Well, you would think if we copied what we have here…in cell C11, which is to sum up the range C6 to C9,…we would get the same value here,…using the same range, C6 to C9.…
Well, the fact is, Excel is smart enough…to use something called Relative Addressing.…It knows if we copy the formula in column C to column D,…that it should use the numbers in column D,…and the same thing for column E.…So, let's see how it's done.…Now, you could use Copy and Paste,…right-clicking or going up to the Home tab…
- Create new workbooks
- Work with text
- Add formulas and functions
- Use Auto Fill
- Format data
- Manage rows and columns
- Share and print workbooks
Skill Level Beginner
1. Getting Started with Excel 2016
2. Modifying Worksheets
3. Sharing and Printing Workbooks
Printing workbooks3m 22s
Next steps1m 1s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.