HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: How to Clear the Values while Keeping Formulas

Excel 2007: How to Clear the Values while Keeping Formulas

If you are constantly using a spreadsheet that requires you clear the values but retain the formulas, it can be painful to go through and select each field individually for deletion. Excel makes it easy to do this in just a few steps.


1. Open the Excel worksheet containing the values and formulas.

2. Press Ctrl+G to bring up the Go To dialog box.

3. Click the Special button in the bottom-left corner of the box.

4. In the Go To Special dialog box, select the Constants radio button. Now check the Numbers checkbox underneath Formulas. Make sure that the Text, Logicals, and Errors checkboxes are unchecked.

5. Click the OK button.

6. All fields containing values and not formulas will be highlighted. Press the Delete key on your keyboard to clear out the values.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android
0
Would love your thoughts, please comment.x
()
x