Microsoft Office Tutorials and References
In Depth Information
Converting Formulas and Values
Converting Formulas and Values
If you have a range of cells that contain formulas, you can convert the cells to values only.
This is useful when you have a range of cells that you don’t want to change anymore. You
use the Paste Special command to paste the contents of the selected range back into place
as a value instead of a formula. If you’re working with an input form in Excel, you prob-
ably need to delete values, but keep the formulas. You can do it with the help of the Go To
Special dialog box.
Convert a Formula to a Value
Select the range of cells with formulas you want to convert to values.
Click the Home tab.
Click the Copy button.
Search JabSto ::

Custom Search