Excel2016 How does data in multiple workbooks synchronize changes?
1, open to modify the work thin, found in more than one worksheet in Shandong after the omission of a province word, the work efficiency will be very low
2. When we click the "Find and select" Drop-down menu on the Start toolbar, select "Replace" menu item in the Popup
3, in the Open Find and Replace window, we find content in the input of Shandong, in the replacement for the import of Shandong Province
4, Next we click the "range" drop-down menu, in the Drop-down menu, select "Workbook" menu item
5, and then click the "Replace All" button
6, then will pop the replacement completed picture, directly click on "OK" button on it.
7, to the worksheet can be seen, all the errors have been modified correctly
8, if there are more complex replacement content, you can click the Find and Replace the window in the "Format" button, set the compound condition of the way to