eHow launches Android app: Get the best of eHow on the go.

Search
Now in the UK!
  1. Home »
  2. How To Videos »
  3. Computers »
  4. Computer Software »
  5. Financial Software »
  6. How to Delete Microsoft Excel Values, Keep Formulas

How to Delete Microsoft Excel Values, Keep Formulas

Video Preview
Rate: (6 Ratings)
2 Comments Post a Comment
Add to Playlist | Whats This? I Did This Whats This?

Summary: In Microsoft Excel, you can create a worksheet that will be used to input numbers, with formulas set to perform calculations on those input numbers (known as values). You can use the worksheet repeatedly by clearing the values while retaining the formulas. For instance, you might create a monthly budget where you can save the current month’s budget with next month’s name, then delete this month’s data leaving the formulas for next month’s budget. This tip tells you how to quickly delete those values while retaining the formulas.

Views:
3,505
Member
By Barbara Raskauskas
User-Submitted Video

Aside from my husband, I have two great passions: flower gardening and decorating for the Christmas season. I love the snow, but always welcome spring and feel blessed to be able to...read more

Difficulty: Moderate
Instructions
  1. Step 1

    Create or open a Microsoft Excel worksheet that contains values and formulas where you need to delete the values, but not the formulas.

  2. Step 2

    Open up the Go To dialog box by pressing F5 or CTRL-G.

  3. Step 3
    Special Button
    Special Button

    On the Go To dialog box, click the Special button. The Go To Special dialog box will open.

  4. Step 4
    Constants
    Constants

    On the Go To Special dialog box, click to fill the Constants button, and if not also filled, click on Numbers. Press OK.

  5. Step 5
    All Values Selected
    All Values Selected

    All the cells with data in them will be highlighted making them easy to delete in the next step.

  6. Step 6
    Values Deleted
    Values Deleted

    Press the delete key to delete all the values. The formulas remain. Click anywhere in the worksheet to get out of the selection mode.

Comments  

sbp15 said

Flag This Comment

on 7/9/2008 Nice tip,thanks for sharing

amylaine said

Flag This Comment

on 6/8/2008 Great instructions, thanks for sharing.

Post a Comment

Post a Comment

eHow Article: How to Delete Microsoft Excel Values, Keep Formulas

Related Ads

  • See How Others Did It
  • Have you done this? Click here to let us know.
Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow's Computers Expert.

Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.

Partner Sites
eHow Computers
eHow_eHow Technology and Electronics