How to drag a formula to multiple cells in excel
How to Copy a Formula to Multiple Cells in Excel : Using Microsoft Excel
Timecodes:
hi my name is Ted and today I'm going to
show you how to copy a formula into
multiple cells in Excel I have a
spreadsheet setup here with a couple of
different columns x and y and I'm going
to enter a formula into the Z column so
let's just make up a formula as in any
formula we start with an equal sign so I
type equals and then I click on X and
let's say we want to do x squared so
I'll do the the square the exponent
symbol and a 2 and then let's add just
for fun let's add Y cube so Y and the
exponent symbol and 3 and we hit a
return and there's the result of the
formula in cell c4 now let's we want to
copy the formula into all of the other
nine cells and it's very simple all you
do we could go up and we could say copy
and then paste but there's a nice trick
that you can do that's much simpler
which I highly recommend which is to
move the cursor until it's at the bottom
right and let me just scroll in so you
can see what I'm talking about here you
want the symbol to change to a solid
plus like that when it does that then
then click it and hold the mouse down
and drag the cursor down until you get
to the bottom of the cells that you want
to copy and and you're done
the the cell if we start and cell D
excuse me c4 and start scrolling down
we'll see that the formula up here in
the end of M the formula bar right here
automatically updates so it started out
with referring to a 4 and B 4 and then a
5 and B 5 and so on and so on so that's
a very very quick way of doing it
that I use all the time now you may have
noticed that I have another number up
here and I say a equals 10 and I did
that intentionally what I want to do is
show you something else that that's very
important when you're
when you're doing a lot of work with
formulas in Excel and that is to let's
say we want to use that number 10 in our
formula but we want it to be the same we
it's not like the X's and the Y's where
it's a different pair of numbers that we
use on for each value of Z we always
want to use this value in cell b1 so
what I'm going to do is I'm going to go
to the original formula I typed in up
here and I'm going to put my cursor in
the formula bar and I'm going to say
let's say we want to add that number so
plus and then I'm going to go up here
and I'm going to click on cell b1 now
you may anticipate what's going to
happen now when I go to copy that
formula down it's going to change it's
called a relative reference when I copy
it down to cell c5 it's going to look
for cell b2 and and let me just go ahead
and do that I'm going to hit return and
we're going to copy the formula down and
into cell c5 and you and now we're going
to click in cell c5 and it's looking for
something in b2 which there's nothing
there and if we were to go down to the
next one to b3 it's going to try to do
something with this Y so so clearly
that's not what we want to happen we
want to always refer to cell b1 so I'm
going to do an undo because I didn't
want to enter that in I'm going to go
back to the formula here and I'm going
to I'm going to what we want to do is we
want to make b18 an absolute reference
not a not a relative reference and to do
that it's in Excel if you use the dollar
sign before the row reference and thus
and that column reference it means when
y come when I copy that formula I always
want it to be that that exact cell so I
type a dollar sign before that a D and a
dollar sign before the one and I hit
return and now when I go in and I and
what you can do is you can do just what
I did the first thing I showed you is go
to cell c4 make the cursor change to the
solid plus sign and drag it down and now
it's not a very interesting formula here
but if we go down to the bottom here and
actually this is something else is good
to know if you double click on the on
the cell that has a form
it is going to highlight the cells that
it uses and you can see it still uses b1
so so what we wanted to do worked in
that we copied the absolute reference in
other words we use cell b1 for all of
the in all of the formulas so I hope
this has been helpful
I'm Ted and today I showed you how to
copy a formula into multiple cells in
Excel thank you for watching
Related queries:
how to move formulas to different cells in excel
how to move multiple formula cells in excel
how to apply same formula to multiple cells in excel
how to drag multiple cells in excel
how to copy a formula to multiple cells in excel
how to add round formula to multiple cells in excel
