How Do You Delete Microsoft Excel Values, Keep Formulas?
Create or open a Microsoft Excel worksheet that contains values and formulas where you need to delete the values, but not the formulas. Open up the Go To dialog box by pressing F5 or CTRL-G. On the Go To dialog box, click the Special button. The Go To Special dialog box will open. On the Go To Special dialog box, click to fill the Constants button, and if not also filled, click on Numbers. Press OK. All the cells with data in them will be highlighted making them easy to delete in the next step. Press the delete key to delete all the values. The formulas remain. Click anywhere in the worksheet to get out of the selection mode.
