When copying a formula from one cell or range to another, it is important to have the correct reference to the cells in the formula. In this video, learn how to use and the difference between relative, absolute, and mixed references in formulas.
- [Instructor] When we insert a formula … into our worksheet, … if we're going to be copying … that formula to other cells, … we want to make sure … that our references are correct. … After watching this video, … you'll understand and know how to use … a relative reference, … an absolute reference, … and a mixed cell reference. … Let's jump right into our references workbook. … And we'll first take a look … at our relative and absolute worksheet. … Now by default a cell reference … is a relative reference. … And that means that the reference … is relative to the location of the cell. … So for example, … let's insert a formula … that looks at the invoice amount … and subtracts the payment amount. … I'll start with an equal sign, … click in cell C10, … type a minus sign and click in cell D10. … So that is our relative reference. … I'll hit enter. … And because it's a relative reference, … I can copy this formula all the way down, … and our results will be correct. … It will always be looking over to the left, …
- Importing data
- Formatting worksheets and workbooks
- Exporting workbooks
- Pasting data
- Modifying columns, rows, and cells
- Formatting cells
- Conditional formatting
- Creating tables
- Filtering and sorting table data
- Using references
- Performing calculations with functions
- Formatting text with functions
- Creating charts
- Taking the practice exam
Skill Level Intermediate
Who should take this course?1m 15s
1. Microsoft Office Specialist Exam Overview
2. Manage Worksheets and Workbooks
3. Manage Data Cells and Ranges
4. Manage Tables and Table Data
5. Perform Operations Using Formulas and Functions
6. Manage Charts
7. Final Practice Exam
- 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.