From the course: Learning Excel 2019
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding cell references when copying and pasting - Microsoft Excel Tutorial
From the course: Learning Excel 2019
Understanding cell references when copying and pasting
- [Instructor] When you add formulas or functions to your worksheet here in Excel 2019, odds are good you're going to need that formula elsewhere. Such is the case with our Leaf and Mortar Revenue sheet here, LMREvenues0105, if you're catching up. We just added the sum function here to cell C11. When we click in that cell, we see the answer on the formula bar. It's the sum function that's summing up the numbers in the range C6 to C9. So we need to do that for February and March, as well, and yes, we could go to cell D11 and fill in that cell with the appropriate function and range, which would be D6 to D9 and then go do it again over here for column E, but why repeat ourselves when Excel uses something by default known as relative cell addressing. That means if we come over here to cell C11 and copy this function or formula and then paste it over here in column D, it's actually going to use the range D6 to D9, and if we paste it over here in cell E11, you've got it, it'll use the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.