Hi, all
I have tried to search and dig Excel but I could not find a way to specify rows in order to replace word. Is there any trick to replace word in all sheets in the workbook but only in specific rows?
Hi, all
I have tried to search and dig Excel but I could not find a way to specify rows in order to replace word. Is there any trick to replace word in all sheets in the workbook but only in specific rows?
1. Press Ctrl key to select multiple sheets you want to find and replace at the meanwhile.
Tip: Holding the Ctrl key, you can select multiple nonadjacent sheets with clicking each sheet in the Sheet Tab bar; Holding the Shift key, you can select multiple adjacent sheets with clicking the first sheet and the last one in the Sheet Tab bar.
2. Then press Ctrl + H to open Find and Replace dialog, then type the text you want to replace into Find what textbox, and the text needed to be replace with into the Replace with textbox.
3. Click Replace All. And a dialpg pops out to tell you how many replacements have been made.
4. Click OK > Close to close dialogs. Now the texts have been replaced.
Find and replace in the whole workbook.
1. Press Ctrl + H to open the Find and Replace dialog, type the text you want to replace into Find what textbox, and the text needed to be replace with into the Replace with textbox.
2. Click Options to expand the dialog, then select Workbook in the Within drop down list.
3. Click the Replace All button. Then a new dialog pops out and shows how many replacements have been made.
4. Click OK > Close to close the dailogs. Then all the texts you specified have been replaced in the whole workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks