How to bulk replace Excel workbooks with multiple table data

you often encounter data that you want to find or replace on multiple worksheets with wood? Are you still opening each worksheet to find replacements? If the workbook file contains a large number of sheet, this is a big project, repetitive cumbersome and error-prone, but most people will not be the method of batch. How do you break it?

Use an example to speak: The following Excel workbook is a collection of original tables that give payroll notifications to employees. Sheet1 to SHEET4 from the preservation of 4 different departments of staff records, these employees are living in the "Wan Shounan Road", but due to the negligence of the input personnel, all are lost to the longevity road, although the lack of a word, But all the tables are on the wrong address. Now you need to quickly add a "South" to the "longevity Road" in all of your tables, how do you make it quick?

First press the CTRL+H key combination to open the Find and Replace dialog box.

In the text box, enter the Find content "longevity Road" and replace the content "Wan Shounan Road", click the Options button to open the detailed options for finding and replacing.

In the detailed replacement window, change the range selection from the default worksheet to workbook, and click Replace All.

Displays the total number of "Replace all complete" and replace.

Closes the replacement window. Switch to the rest of the worksheets to view, found all the "longevity Road" automatically added the word "South".

This is a one-time deal with a number of worksheets to find and replace data, both fast and accurate! For those dozens of or even hundreds of workbooks, this is the "Savior" Ah!

Don't go away, the problem is not so simple. Sometimes we want to find or replace error conditions more stringent, such as only the formula range or limited to a certain color font cells. What to do?

Never mind, finding and replacing multiple worksheets in an Excel workbook is not limited to the contents of ordinary characters. You can also find the formula content by using the formula option in the look in scope, and you can also set up specific content (such as a specified color or font, etc.) that you want to find only in a particular format, and content that is not in this format is excluded. This expands the scope and flexibility of the search and replace usage.