Share via

How to EASILY Search Entire Excel Workbook?

Anonymous
2014-07-11T15:34:31+00:00

I have an Excel workbook with several worksheets in it. I need to be able to quickly search the entire workbook (all sheets). I know that I can right click on one of the tabs, select all sheets, then click the Find button. I need a keyboard shortcut, a button shortcut, or just an easier way to do this.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-07-11T15:45:24+00:00

    CTRL+F,  Give your find what word

    Then either click Options or Click Alt+T

    In option button, select workbook from "within" drop down

    Now if you again do CTRL+F, you will find it selected as by default.

    136 people found this answer helpful.
    0 comments