Find and Replace Formatting in Excel

How to Find and Replace Formatting in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Find and Replace Formatting in Excel

Excel’s Find and Replace features can find and/or replace formatting in addition to text and information. Use the Find and Replace Formatting option when you want to change all instances of a particular formatting choice at once.

Using Find and Replace Formatting

  1. Click the Find & Select button on the Home tab.
  2. Select Replace.

    Press Ctrl + H to open the Find and Replace dialog box

    Find and Replace Formatting
  3. Click the Options button.
  4. Click the Find what: Format button.
    Find and Replace Formatting

    The Find Format dialog box opens. Here you can select any type of formatting you want to look for in the workbook.

  5. Select the formatting you want to find.
  6. Click OK.
    Find and Replace Formatting
  7. Click the Replace with: Format button.
    Find and Replace Formatting
  8. Select the new formatting options you want to use.
  9. Click OK.
    Find and Replace Formatting

    Once the formatting options are set, you’re ready to begin finding and replacing the formatting.

  10. Select the Find or Replace option you want.
    • Click Find Next or Find All to locate the formatting you want replace before replacing it.
    • Click Replace to change cells one at a time.
    • Click Replace All to replace every instance of the formatting at once.
  11. When you choose to replace all instances of the formatting, the dialog box lets you know how many replacements were made. Click OK.
  12. Click Close.
    Find and Replace Formatting