anything in Excel...

It's Excel-o-lozy...

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...

0 comments: