From the course: Excel 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Copying a formula into adjacent cells
From the course: Excel 2019 Essential Training
Copying a formula into adjacent cells
- [Instructor] In Excel, it's not uncommon that after you've written a formula, you need to copy it either rightward into adjacent cells or downward into adjacent cells. And as we're about to see, it's a huge time saver to be able to do this. In this particular worksheet, called CopyFormulas, and we're in the Workbook 03, Creating Formulas and Functions. In cell B4 is a formula. I wanted to double-click it so we can see it better. It subtracts the two cells above it. When you copy a formula, you copy that kind of a relationship. If we were to copy and have the exact same formula over in C4 that we have in B4, it's not gonna make any sense. We're gonna get the answer 20 and we want the answer, of course, to be the subtraction of these two cells. When we copy a formula, we copy the relationship. And we do it with the fill handle in the lower right-hand corner. So, pointing to the fill handle, notice how it changes its shape to be a thin plus. Just gonna drag this over into Column G. And…
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.