Find and Replace in Microsoft Excel

in Microsoft Excel

I want to find specific words and replace them with new words

Ctrl + H = Opens the Find and Replace dialog box
Excel Find and Replace dialog box showing the replace options
The Find and Replace dialog box in Excel
  1. Open your Excel spreadsheet
  2. Press Ctrl+H to open Find and Replace and select "Replace"
  3. Enter the value to find in the "Find what" field
  4. Enter the replacement value in the "Replace with" field
  5. Choose your search options:
    • "Within": Sheet or Workbook
    • "Look in": Formulas, Values, or Comments
  6. Click "Replace" or "Replace All"

I want to find specific words (find only)

Ctrl + F = Opens the Find dialog (quick find)
Excel Find dialog showing search options
The Find dialog in Excel
  1. Open your Excel spreadsheet
  2. Press Ctrl+F to open the Find dialog
  3. Type the value you want to find in the search box
  4. Choose your search options if needed:
    • "Within": Sheet or Workbook
    • "Look in": Formulas, Values, or Comments
  5. Click "Next" to move through matches