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.
Leave a Reply