User Login

Help Community Login:

How To Remove Values but Keep Formulas in MS Excel 2007

missb's picture
missb
Banned Member (Way To Go!)
Relationship Status:
Single & Not Looking
Joined: 01/16/2009
Posts: 3109
Drops: 3812
Mood: Weird

Here's a nifty way to delete all values entered into a workbook while keeping the formulas.

  • Open the Excel worksheet containing the values and formulas.
  • Hit "Ctrl G", that will bring up the Go To dialog box
  • Click on "Special"
  • Then select "Constants". Now check the "Numbers" checkbox underneath "Formulas". Make sure that the Text, Logicals, and Errors checkboxes are unchecked.
  • Click OK

All fields containing values and not formulas will be highlighted. Just press "Delete" and all values will be deleted, but will leave the formulas.
I Averaged: 4 | 2 votes


Read More ...





Who's New

bebiiee's picture
JustLOVETheGeek's picture
jhonzeth's picture
kaushalmalkan11's picture
avinash.5107218's picture
Raez's picture
MondayTuesday09's picture
sabrina_marie's picture
Tallen's picture
aaron420's picture
Viktor123's picture
paeltc's picture
dimpy123's picture
dfuller4747's picture
Bob the Observer's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2017
TOS | Privacy Policy