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

henta2002's picture
Vanillachinchilla's picture
versioniii's picture
xgensolutions's picture
OkwuteAgu's picture
CB_Latin's picture
GrimRapper's picture
glrobins's picture
hady's picture
Jessica Davis's picture
CRowmAN's picture
redd993's picture
Austeen Legitt's picture
JimGuth's picture
ethan121's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop™ 2009-2020
TOS | Privacy Policy