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 probably 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. ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
