drag
## How to Copy a Formula to Multiple Cells in Excel : Using Microsoft Excel

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

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