How to Clear the Values and text while Keeping Formulas?

In spreadsheet that requires you to clear the values but retain the formulas in Excel.

Step1: Open the Excel worksheet containing the values and formulas.


: Go to dialog box, click the Special button.


: Select the Constants radio button.


: Now you want to clear the numbers choose “Numbers” or “Text” under the formulas. Click ok.


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


About d2ml
We are team of young engineers, eager to know more in Intellectual Property as new bee to this field. This blog is designed for professional new to this field. We like to share the things which we explored during course of journey

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: