How to Search Whole File in Microsoft Excel

To search the whole file – not just the current sheet – go to the Find and Replace window (Ctrl + F), click Options and next to Within, select Workbook.

No comments:

Post a Comment