Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

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

  • lightyellow_01.jpg Select the range of cells with formulas you want to convert to values.
  • lightyellow_02.jpg Click the Home tab.
  • lightyellow_03.jpg Click the Copy button.
  • lightyellow_04.jpg Click the Paste button arrow, and then click Paste Special.
  • lightyellow_05.jpg Click the Values option.
  • lightyellow_06.jpg Click OK.
  • lightyellow_07.jpg Press Esc to cancel Copy mode.

Delete Values and Keep Formulas

  • lightyellow_01.jpg Click the Home tab.
  • lightyellow_02.jpg Click the Find & Select button, and then click Go To Special.
  • lightyellow_03.jpg Click the Constants option.
  • lightyellow_04.jpg Select the Numbers check box, and then clear the other check boxes under Formula.
  • lightyellow_05.jpg Click OK.
  • lightyellow_06.jpg Press Delete to remove the selected values.
  • + Share This
  • 🔖 Save To Your Account