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...
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:
Post a Comment