How to search within the entire workbook in excel

How to search or find data within the entire workbook in Microsoft excel.

Generally if we try to find something we use find and replace in excel and within that if we search something it search within the active worksheet only.

Sometimes we need to search the whole workbook to find or even replace data. Now how do you do that?

Well, quick settings will allow you find data inside a whole workbook. So lets learn how to do it.

Step 1: Open the find and replace pop up box by pressing CTRL+F or by clicking the Find & Replace on the menu bar.

Step 2: Click on the "Option"

Step 3: Click on the "Within" Drop down list and select "Workbook"

Done. Now you can search the entire workbook. You can also find and replace anything within the whole workbook.

#FindAndReplace #workbook

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[abayomi]

This is amazing.

May God bless you.

[halonbori]

Thank you my brother to share this wonderful tip!

[tasnimba]

Thank you a lot, this tutorial saved my day LITERALLY!!

[Satishma]

Excellent video... Thanks for sharing.. 👏👏👏

[waisans]

thank you so much bro, nice sharing ♥♥