1

How do I find and replace a word in one Excel file across multiple worksheets in the same file?

  • Be aware that 'find' will NOT find on any sheets that are hidden, so you must first un-hide any hidden sheets that you want to be searched. – Sean Apr 27 '18 at 17:00
6

In the "Find and Replace" dialog box click the "Options >>>" button and change the "Within" drop down from "Sheet" to "Workbook".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.