February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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. ...