Use the Replace tool to fix errors or swap words. For example, you might want to correct repeated mistakes.

  1. Go to the Home tab and select Find & Select, then click Replace.

  2. In the dialog box, type the text you want to find in the Find what field.
  3. Type the new text in the Replace with field.

  4. Click Find Next to review the first match.
  5. Choose Replace to change one instance, or Replace All to change all.

💡 Tip: Be careful with Replace All, as it changes everything without review.


When finished, click Close to exit. These tools make editing in Excel much faster and easier.


Next and Previous Buttons