- Introduction
- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
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.
- Click the Paste button arrow, and then click Paste Special.
- Click the Values option.
- Click OK.
- Press Esc to cancel Copy mode.
Delete Values and Keep Formulas
- Click the Home tab.
- Click the Find & Select button, and then click Go To Special.
- Click the Constants option.
- Select the Numbers check box, and then clear the other check boxes under Formula.
- Click OK.
- Press Delete to remove the selected values.