The information in this article applies to:
- Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
- Microsoft Excel for OS/2, versions 2.2, 2.21, and 3.0
If you are working with cells that contain both constant values and
formulas, and you want to clear the constant values, leaving the
formulas intact, use the Go To Special dialog box (Select Special dialog
box in versions previous to version 5.00) to select the cells you want to
clear. Once the appropriate cells have been selected, use the Edit Clear
command as usual. To do this, follow the steps below:
- Select the range of cells containing the constant values and
formulas. If the entire worksheet is to be cleared of values,
select only a single cell.
- Microsoft Excel Version 5.00
----------------------------
From the Edit menu, choose Go To. In the Go To dialog box, choose
Special.
Microsoft Excel Versions Previous To Version 5.00
-------------------------------------------------
From the Formula menu, choose Select Special.
- Select the Constants option, then select the check boxes for the type of
constants you want to clear.
- Choose OK. The cells you want to clear are selected.
- From the Edit menu, choose Clear and choose the option that matches
the data you want to clear. Choosing the Formulas option clears the
contents of the selected cells only, so you need not worry about
the formulas that are not selected.
- Choose OK.
|