Copy Initial Calculated with airSlate SignNow

Link formula form

in this video I'm going to show you a low cut come in handy when you're copying formulas from one range to another range and you don't want the cell references to change so now I'm not talking about the dollar sign to fully fix the cell references because sometimes you have a mix of relative and absolute referencing in your formulas and normally when you copy one range to another you do want these relative references to update but there might be a reason that you don't want that to happen so one way is like to go in the formula bar copy the formula and paste it to another cell so for one cell that's fine but what if you have a lot of cells and they use different relative referencing right so that's going to become a major headache so now I'm going to show you one trick that you can use to handle just that here's a sample dataset we have numbers that are input in this range and we have formulas in here now the formulas are different formulas so we have a different set in here than what we have in here let's take a look at what's inside here we're calculating the various actual to previous year okay so we need these two columns for revenue and when we pull it across we get that for profit as well okay so in this case this set is identical we can pull it across and we can pull it down but this set right here that's different because that's actual to budget right so we can't copy this over here because then that would be previous year to budget right and we want actual to budget now what we want to do is this we want to be able to copy this whole area and paste it down here but still maintain the original references because check this out Excel updates the references right and in most cases it's good that it does that because that's what we want but let's say in this specific case we don't want that we wanted to keep the original references now one way to handle this is that you copy the formula from the formula bar or you press f2 and you go in edit mode and you copy this then you go to the cell where you want your formula in you go in edit mode or you go to the formula bar and you paste it and when you press ENTER then you get the correct formula but this can be quite time-consuming if you have different sets of formulas like I have in the sample data and it can be a bit risky as well because you might not be aware that this formula is actually different to this set so you might just do it for one of them and then copy all the way across and all the way down and actually...