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

chap2315's picture
GeekGirlFTDropOG's picture
Pancake's picture
Stephenhaw909's picture
travis's picture
hawkeyefxr's picture
Michaelchung2002.'s picture
Norielm19's picture
vankemp68's picture
ajfan91's picture
Circuit VPN's picture
itsjusme's picture
Wcochran271's picture
braybray's picture
Redneck's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop™ 2009-2021
TOS | Privacy Policy