Copy Several Formula with airSlate SignNow

Extend formula diploma

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...