To do this we first need to unlock all the cells and then select and lock only those cells that have formulas in it. And by holding the right click drag the range to the right side and instantly bring it back to the original place and drop it. Under items scroll down to Formula and then select with numeric constants.
In the results pane you will now see details of all formula within the workbook that constant a numeric constant or a hard-coded value within a formula.
This is because it calculates after every change or update. Select the cell containing the formula and recreate the entire formula. If you want to copy both calculated results and the formulas to other cells without changing their values Kutools for Excels Exact Copy tool can help you quickly copy both numbers and their formulas without changing their values to other cells in Excel. Create More Complex Formulas.