Microsoft Office Tutorials and References
In Depth Information
Deleting Values While Keeping Formulas
Deleting Values While Keeping Formulas
A common type of spreadsheet model contains input cells (which are changed by the user) and
formula cells that work with those input cells. If you want to delete all the values in the input cells
but keep the formulas intact, here’s a simple way to do it:
1. Select the range that you want to work with.
If you want to delete all nonformula value cells on the worksheet, just select any
single cell.
2. Choose Home
Find & Select
Go To Special.
This step displays the Go To Special dialog box.
3. In the Go To Special dialog box, select the Constants option and then select Numbers.
4. Click OK, and the nonformula numeric cells are selected.
5. Press Delete to delete the values.
If you need to delete the value cells on a regular basis, you can specify a name for the input cells.
After completing Step 4, choose Formula
Define Name to display the New
Name dialog box. Enter a name for the selected cells — something like InputCells is a good
choice. Click OK to close the New Name dialog box and create the name.
Defined Names
After naming the input cells, you can select the named cells directly by using the Name box —
the drop-down list to the left of the Formula bar. Then press Del, and they’re gone.
Search JabSto ::

Custom Search