Populate Signed Formula with airSlate SignNow

Fax populated formula

hi I'm Ted today I'm going to show you how to populate a formula into all rows in Excel this is something that's very common in Excel anytime you have formulas you you're almost surely going to want it to know how to do this so I've got any spreadsheet set up here and I'm just going to enter in a very simple formula I've just got the formula shown up here it's a quadratic formula and just to show you a couple of very important points I've got the coefficients of the polynomial here as values and this is a really good thing to do if you have something that is going to be in a formula to actually have the value somewhere in a cell where you can see it so what we're going to do is we're going to start typing in the formula and there's a little trick I'm going to I'm going to show you as we as we do it so we're going to type equals and then we're gonna click up here because we're you know the first one is the C 0 look at the constant coefficient in the polynomial now I'm going to show you the trick when we copy this formula down to multiple rows the cell references are going to change in other words it's going to the what's in d4 when we copy it down to this next row is going to want to do d5 and then the next one is going to be d6 and you can see very soon we're going to get into trouble because we're going to start it's going to be wrong first of all we want to make this an absolute cell reference meaning it won't change the trick to doing that when you're at the point where you've just entered in that cell reference on a Macintosh you type option T and watch what happens it's oops I'm sorry not option T on a Macintosh you type command T and you notice what happens is that it changes the d4 to a dollar D dollar for what that says the dollar sign in excel says that's going to be an absolute reference meaning it doesn't change when you copy it so that means that when that formula is copied elsewhere that entry in the formula is always going to be cell d4 if we type command T again we we get to where it it's an absolute row reference but it's a variable column reference if we do it in its now an absolute column reference but a variable row reference and then we we do it a couple more times now we've got it so that it's variable for both of them and now we go back to what we wanted where it's dollar D dollar four so again on a Macintosh you type command T when you're entering in the cell reference and just keep going until you get the combination that you want on a Windows system instead of command T you just type f4 all right so now we could continue entering in the formula so we're going to now go plus and then the the the linear coefficient and we type command T and then then we kind of type at times and click on the X and there we want it to be a variable reference we want that to change when we copy the formula down actually no we want it to only have the we don't want the column to change because we always want the formula anytime we copy it to still refer to this X so now we're going to do the command T until it doesn't change the B so as dollar b9 meaning it'll always be column B so now we're just going to keep going plus this guy here command T times the X once again command T a couple of times and then finally it's a squared so we type to the second power and we type a return so there we go now to copy the formula finally you click on the formula click on the cell where the formula is and you move your cursor until it changes to a solid plus and you hold it down and copy down to drag it down to all the rows so I hope this has been helpful I'm Ted and today I showed you how to populate a formula into multiple rows in Excel thanks for watching