How do I find and replace a word in one Excel file across multiple worksheets in the same file?
1 Answer
In the "Find and Replace" dialog box click the "Options >>>" button and change the "Within" drop down from "Sheet" to "Workbook".
In the "Find and Replace" dialog box click the "Options >>>" button and change the "Within" drop down from "Sheet" to "Workbook".