Cut and paste formulas

Don't cut and paste formulas

As a general rule, don't cut and paste formulas. This is because if you cut and paste a formula the relative references don't change. Just study the example below for better understanding

For simplicity assume you have the values 4 in cell A1 and 5 in cell B1. You enter the formula =A1+B1 in cell C1. If you normally copy the formula from C1 to C2, then the formula would automatically change to A2+B2 in cell C2. But if you cut the formula from C1 and paste it to C2 then the formula would remain the same. So, the next time you cut and paste a formula be sure of what you are doing.