Trick-pro - Find option...

Let's know a bit more bout "Find" box...

• Ctrl + F or Shft + F5
   = shows Find Box
  Logic - F means Find 
• Ctrl + H
  = displays Find Box with Replace option selected
  Logic - Don't say why Ctrl+R is not used to Replace, as that shortcut is to Fill Right, may be H, is near to F key, LOL...
   
• Shift + F4
  = Repeats search with last criteria
  Logic - F4 means repeat last action, so Shift+F4 is to repeat search last Find criteria 
• If you can't jump to the cell through "Find" on a value that you can see directly:
  = make sure that in Find Box "Options" under "Look in" dropdown "Value" (2nd option in list) is selected.
   

Now, How to find in Whole Workbook rather than activesheet...

• To Search in all worksheets:
  = make sure that in Find Box "Options" under "Within:" dropdown "Workbook" (2nd option in list) is selected.

Again, What if you wish to search in Some Worksheets rahther than whole workbook...

• Simple, select only these Worksheets that you wish to search in...
  But now make sure that in Find Box "Options" under "Within:" dropdown "Sheet" (2nd option in list) is selected.
• Now, don't ask me how to select few or non-adjacent worksheets...
  click here to know how to do it...