+ Reply to Thread
Results 1 to 5 of 5

Limit Search & Replace's Replace All?

  1. #1
    Bob@1800-mail.com
    Guest

    Limit Search & Replace's Replace All?

    I there a way to limit search and replace's (Ctrl + H) replace all to
    just a selected cell range, without using VBA?

    I like replace all because it is fast, but I'm concerned about it
    changing cells I don't want changed.


  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,264
    select the range by highliting it,
    then find and replace,
    this should only replace in the range highlited

  3. #3
    Dave Peterson
    Guest

    Re: Limit Search & Replace's Replace All?

    And make sure that the selection contains at least 2 cells--else all cells will
    be used.



    davesexcel wrote:
    >
    > select the range by highliting it,
    > then find and replace,
    > this should only replace in the range highlited
    >
    > --
    > davesexcel
    >
    > ------------------------------------------------------------------------
    > davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
    > View this thread: http://www.excelforum.com/showthread...hreadid=563969


    --

    Dave Peterson

  4. #4
    RagDyeR
    Guest

    Re: Limit Search & Replace's Replace All?

    Unless you *Don't* use "Replace All" for single cells.
    Just click "Replace".
    --

    Regards,

    RD
    ----------------------------------------------------------------------------
    -------------------
    Please keep all correspondence within the Group, so all may benefit !
    ----------------------------------------------------------------------------
    -------------------

    "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
    news:44C245A3.95E4FC6F@verizonXSPAM.net...
    And make sure that the selection contains at least 2 cells--else all cells
    will
    be used.



    davesexcel wrote:
    >
    > select the range by highliting it,
    > then find and replace,
    > this should only replace in the range highlited
    >
    > --
    > davesexcel
    >
    > ------------------------------------------------------------------------
    > davesexcel's Profile:

    http://www.excelforum.com/member.php...o&userid=31708
    > View this thread: http://www.excelforum.com/showthread...hreadid=563969


    --

    Dave Peterson



  5. #5
    Saruman
    Guest

    Re: Limit Search & Replace's Replace All?

    Highlight the cells as previously suggested, once you have run the find all,
    then re highlight the same selection and if you click replace all, only the
    highlighted cells are replaced.

    This is in Excel 2003

    --
    Saruman

    ---------------------------------------------------------------------------
    All Outgoing Mail Scanned By Norton Antivirus 2003
    ---------------------------------------------------------------------------

    <Bob@1800-mail.com> wrote in message
    news:1153571350.170799.122500@i42g2000cwa.googlegroups.com...
    > I there a way to limit search and replace's (Ctrl + H) replace all to
    > just a selected cell range, without using VBA?
    >
    > I like replace all because it is fast, but I'm concerned about it
    > changing cells I don't want changed.
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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