Results 1 to 2 of 2

Thread: Find and Replace in selected cells only

  1. #1

    Find and Replace in selected cells only



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have been trying to do a find and replace on selected cells only, but it seems to replace in the entire sheet, although not consistently. Can't quite seem to nail down when it does the whole sheet and when it just does the selected cells. Any suggestions on ensuring that replace only takes place on selected cells?
    Thanks
    David

  2. #2
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    162
    Articles
    0


    Register for a FREE account, and/
    or Log in to avoid these ads!

    If you only have one cell selected, it will do the whole sheet. Also make sure you don't have the option to search the whole workbook selected.
    Circumference of a circle = 2πr²



    ²the circle's radius

Posting Permissions

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