Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2008
    Location
    Jacksonville, Florida, USA
    Posts
    142
    Thanks
    52
    Thanked 0 Times in 0 Posts

    Excel 2003 - clear values but not formulas from a range of cells

    Using Excel 2003 - How can I remove only cell data/values, but not formulas, from a range of cells.
    I want to reuse a spreadsheet I created at the beginning of each calendar year. The basic cells containing text only can easily be cleared if desired. But I have not found a way to clear the values from a single cell or a range of cells that contain a formula without clearing both the values and the formulas. I have searched all of the help screens I can think of.
    Dell Inspiron 15R, 8GB, Win7 Home Premium 64bit SP1
    All help truly appreciated!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Select the range of cells
    Edit - goto Special
    Select constants
    Then uncheck the constants you don't want to clear (numbers, text, logical, errors)
    [OK]
    and the appropriate cells are selected. Then [delete]

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    flavet (2011-11-12)

  4. #3
    2 Star Lounger
    Join Date
    May 2008
    Location
    Jacksonville, Florida, USA
    Posts
    142
    Thanks
    52
    Thanked 0 Times in 0 Posts
    Steve - Thanks ever so much for your solution. I wanted to try it out before I thanked you, and sure enough I was having endless problems trying to make the solution work. Tried a dozen different approaches but none worked - at first. I finally stumbled into what I should have been doing right from the start: using the DELETE key on the keyboard, and not the Edit | Delete... key on the Edit drop down menu.

    flavet

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •