Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2000 (2000 9.0.6926 sp3)

    Select Edit | Go To...
    Click Special...
    Select Constants.
    Click OK.
    Press Delete.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (2000 9.0.6926 sp3)

    1.Select Insert, Name, Define.
    2.In the Define Name dialog box, enter the following in the 'Names in workbook' box
    CellHasFormula

    3.Then enter the following formula in the "Refers to" box
    =GET.CELL(48,INDIRECT("rc",FALSE))

    4.Click Add, and then OK.
    5.Select all the cells to which you want to apply the conditional formatting.
    6.Select Format, Conditional Formatting
    7.In the Conditional Formatting dialog box, select Formula Is from the drop-down list, and then enter this formula in the adjacent box
    =CellHasFormula
    8.Click the Format button and select the type of formatting you want for the cells that contain a formula.
    9.Click OK.
    After you've completed these steps, every cell that contains a formula and is within the range you selected in Step 4 will display the formatting of your choice

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (2000 9.0.6926 sp3)

    If you want to do this often, then you can use worksheet protection. Use Format/Cells/Protection to unlock all the cells that contain the things you want to be able to modify/delete, and lock all the cells that contain formulas or other things you do not want to be modified/deleted. Then use Tools/Protection/Protect Sheet to protect the worksheet. Now, if you select a group of cells and press Delete, only the cells that are unlocked will be deleted.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    London, Gtr London, England
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Delete data but preserve formulas (Excel 2000)

    Subject edited by HansV to aid in future searches ("Excel" was not very specific)

    How can you delete the data but preserve the formulas for a given, highlighted, part of a table, please?

  5. #5
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    London, Gtr London, England
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Delete data but preserve formulas (Excel 2000)

    Thanks, everyone, for the suggestions.
    Regards

Posting Permissions

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