Excel: Deleting Formulas from Cells Without Losing Values

• Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0, 5.0
• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0

SUMMARY

In Microsoft Excel, to remove a formula from a cell without losing the resulting value in that cell, do the following:

1. Select the cell (or range of cells).



2. From the Edit menu, choose Copy.



3. From the Edit menu, choose Paste Special.



4. Select Values. Click OK.

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2 2.20 3.0 replace

Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 16, 1999