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
  / excel10tutorial  
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial