+ Reply to Thread
Results 1 to 3 of 3

Find within an Area

  1. #1
    Forum Contributor
    Join Date
    09-25-2012
    Location
    Ventura, united States
    MS-Off Ver
    Excel 2010
    Posts
    346

    Find within an Area

    When using the Find feature in excel, you have the ability to search within the worksheet or the workbook. But is there a way to search within the highlighted/selected region only?? Often times I have the same search item in multiple places within a worksheet, but I want to search in a given column or region only.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,791

    Re: Find within an Area

    If you highlight the block of cells beforehand, then Find & Replace (CTRL-H) will only look in that selected area.

    Hope this helps.

    Pete

  3. #3
    Forum Contributor
    Join Date
    09-25-2012
    Location
    Ventura, united States
    MS-Off Ver
    Excel 2010
    Posts
    346

    Re: Find within an Area

    Holy Crap you're right! I don't know why I feel like I've tried this before and it hasn't worked. That was an easy solution. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1