Share via

Replace within Selected

Anonymous
2022-06-25T15:40:59+00:00

Hi,

It's there a way that I can replace within Selected? The only 2 options available are within Sheet and Workbook.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-06-25T15:51:22+00:00

    If there is a Selection then Find and Replace works within Selection. No need to select Sheet or Workbook.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-06-25T15:52:59+00:00

    Dear Vinson21kv,

    Good day! Thank you for posting to Microsoft Community. I am happy to help you.

    Are you looking for replacing cells for selected range/cells? If so, you can select the range/cells first and then click Replace All in Find and Replace window. It will replace all the matched case within the range/cells you selected.

    If this is not your query, please post back to let me know

    Sincerely,

    Ryan | Microsoft Community Moderator

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

    4 people found this answer helpful.
    0 comments