To lock these numeric values, you need to delete the formula without deleting the calculated results. This is accomplished using Excel's copy and paste feature.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

The Microsoft Excel Status Bar is now more advanced than before with the new ability to copy and paste values.