« Paste Special I | Main | Basic Functions: FIXED »
September 20, 2005
Paste Special II - Removing formulae
The paste special feature is useful for preserving the values in a spreadsheet - but removing the formulae that generated those values. This may be required to preserve proprietary equations.To remove the formulae for a range of cells, select and copy the desired range. Do not unselect the range. Now click on Edit - Paste Special - see below.
Make sure the Formulas box is unchecked. After you click OK, the formula is removed but the value is preserved.
Posted by Dave at September 20, 2005 08:53 PM