Excel Hack 36: Freeze a cell’s formula into its current value
For one reason or the other, you may need to lock the results of a cell’s formula permanently into its current value. There are two ways to accomplish this, quickly: Approach 1: If you are dealing with just a few cells: Step 1: Select the cells and press F2 to get into formula editing mode