Tom’s Tutorials For Excel: Finding and Replacing on All Worksheets

Tom’s Tutorials For Excel: Finding and Replacing on All Worksheets

Sometimes overlooked is Excel’s ability to Find and Replace across all worksheets in a workbook, without needing to select all the worksheets.

• Select any cell in any sheet.
• From your keyboard press Ctrl+H to show the Find and Replace dialog box.

On the Replace tab, select these options and click the Replace All button:
• In the Within field, select Workbook from the dropdown list.
• Selecting Match case kept “Tom” untouched on Sheet3 in cell A3.
• I kept the entire Match entire cell contents field deselected.