How to Copy or Cut a Cell formula in Excel 2016
When you copy a cell which has a formula to another cell the formula copied uses relative reference but if you cut the cell and copy to another cell Excel keeps the formula as it is.
When you copy a cell which has a formula to another cell the formula copied uses relative reference but if you cut the cell and copy to another cell Excel keeps the formula as it is.