How To Remove Values but Keep Formulas in MS Excel 2007

How To Remove Values but Keep Formulas in MS Excel 2007

Malware Bytes Anti-Malware Protection

MalwareBytes is GeekDrop's Favorite Anti-Malware Solution

Act now to get a huge savings on GeekDrop's favorite Backup, Imaging, & Drive Utilities. Also our member's #1 choice!

Mon, 10/04/2010 - 2:46pm (15 years 29 weeks ago)

Tip

missb's picture

missb

is a soulless ginger. :)

Relationship Status:
Single & Not Looking

Joined: 01/16/2009

Drops: 3812

Mood: Weird

Groups: Advice Corner, AWESOME!, Book Worms, Broadway!, Game Group, Geekdrop Cafe, GeekDrop Pub, Jokes, Let's go to the Movies, MOM's Group, Sports Den, The Cooks Corner, U.S. Military, Words of the soul

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.

Read More ...

Who's New

Jack827764's picture

Ronie's picture

Blondie45's picture

eren7662's picture

OutfitHuddle's picture

Woodruffs's picture

UylerUarsson's picture

Fuadtttt's picture

almubarakmubarak88@gmail.com's picture

DylerDarsson's picture

ytbsaucee's picture

Joenwalker's picture

Max's picture

ppiyushs's picture

Florencehg63's picture

facebook codes exploits tips tricks

All contents ©Copyright GeekDrop™ 2009-2026TOS | Privacy Policy