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.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Leave a Reply

Your email address will not be published.

*