1

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

1
  • 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, 2018 at 17:00

1 Answer 1

6

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .