Converting formulas to values
If you have a range of formulas that will always produce the same result (that is, dead formulas), you may want to convert them to values. If, say, range A1:A20 contains formulas that have calculated results that will never change-or that you don't want to change. For example, if you use the RANDBETWEEN function to create a set of random numbers and you don't want Excel to recalculate those random numbers each time you press Enter, you can convert the formulas to values. Just follow these steps:
- Select A1:A20.
- Choose Home> Clipboard> Copy (or press Ctrl+C).
- Choose Home> Clipboard> Paste Values.
- Press Esc to cancel Copy mode.