Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find and Replace errors (2007)

    How should I set about finding and replacing errors within a worksheet? Specifically I want to find all cells that contain #DIV/0! Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find and Replace errors (2007)

    Select a single cell (any cell) in the worksheet.
    Select Edit | Go To...
    Click Special...
    Select Formulas, then clear the check boxes labeled Numbers, Text and Logicals, so that only Errors remains ticked.
    Click OK.
    Excel will select all cells containing an error value.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find and Replace errors (2007)

    Top man..

Posting Permissions

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