Share via

Formatting disappears after find and replace

Anonymous
2021-07-16T15:24:05+00:00

Hi,

I have certain words in various cells in bold font – however, after I do a command such as “find and replace” it will un-do my bold formatting in those cells where words have been replaced. This causes me extra work because I must re-bold all those words. This is a program on my work system so I am not sure which version of Microsoft we have.

How can I stop this from happening in the future?

Thank you!

Microsoft 365 and Office | Excel | For home | 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. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Rich~M 20,355 Reputation points Volunteer Moderator
    2021-07-16T20:34:46+00:00

    Hi Lauren. I am an Excel user like you.

    My Find/Replace action does not change any formatting in the cell where the contents are replaced by default, but I was able to duplicate the result so here is something to check.

    In the Replace dialogue box click on "Options>>". Following the "Find what" and "Replace with" is now a formatting option that should say, as below, "No Format Set". If there is anything else there, click on the dropdown arrow, indicated below, and select "Clear Replace Format". It should then read "No Format Set" and the formatting should not change when you replace data.

    Image

    Reply if you have additional questions or information. Please mark this reply as answered if this solves your question.

    Rich~M

    2 people found this answer helpful.
    0 comments