In this video, learn how to copy a formula or a function to other cells. Discover how relative cell referencing works to automatically use the correct range of cells in the formula or function in the pasted cells.
- [Instructor] When you use a formula or function…for a range of data, as we did with our red 30 revenues here…in cell C11, R30revenues0105 if you're catching up,…you can reuse that formula or function for other…ranges of data that are similar, like February and March.…In other words, we don't have to type in the…sum function and the range for each of these…ranges of data, all we need to do is copy and paste…this one to those other two cells.…
Automatically Excel uses something called relative…cell addressing, it knows if we copy this function…from column C to column D that it should use…the values in column D.…And if we copy and pasted over here to column E,…it should use this range of data in column E.…So you might be tempted to come over here,…go up to the home tab and click copy…or use the keyboard shortcut Ctrl + C and then come over…here and use paste functionality,…but there is a faster way.…
You may have noticed in the bottom right corner…of any cell that's selected this little green handle.…Just click anywhere, you'll see it…
- Explore efficient methods for adding functions and formulas.
- Format text, numbers, dates, and times.
- Save, share, and print your workbooks.
- Recognize how to freeze panes to control your view.
- Recall methods for protecting documents.