The Quick Find Next (Repeat Search without Dialogue Box) – Excel Tip

 

In order to search a text in an Excel File  we need to invoke the “Find and Replace” tool in Microsoft Excel by hitting [Ctrl]+[F] as shown in figure 1.1 below…

Figure 1.1

To search the next occurrence of the text one has to again invoke the same “Find and Replace” dialogue box.

However, not many of us really know that Excel provides a quick way to repeat the search without invoking the Find dialogue. The quick Find Next works as stepped out below…

1. Invoke the “Find and Replace” dialogue box by pressing [Ctrl]+[F] key combination
2. Type the text that you intend to search and click “Find Next” button in “Find and Replace” dialogue box.
3. Press [Esc] key to close the “Find and Replace” dialogue box.
4. Press [Shift] + [F4] key combination to repeat the search without invoking “Find and Replace” dialogue.

I hope you found the tip useful and thank you for reading.

Recover the Deleted Items in Outlook without a recovery tool – Outlook Trick

 

If you don't know what a Hex editor is, you probably shouldn't be hex editing anything, but if you want to try, Google for "hex editor" - UltraEdit is perhaps the best and easiest one to use. Before doing anything to the PST with a Hex Editor, make a copy of the PST, or you may end up losing all of your email.

1. Open the PST in the Hex editor.
2. Delete positions 7 through 13 with the spacebar. Since you're using hexadecimal numbering, this actually clears 13 characters in the following positions:
   00007, 00008, 00009, 0000a, 0000b, 0000c, 0000d
   0000e, 0000f, 00010, 00011, 00012, 00013
   As you clear the characters, the editor displays the code “20” in their position.
3. Save the PST, it is now corrupted.
4. Run the Inbox Repair Tool, SCANPST.exe, to recover the file. Use Windows Search utility to find it. For more information on the Inbox Repair Tool, see KB article 287497
5. The Inbox Repair Tool creates a backup and repairs the damage and recreates the PST.

Open the new PST in Outlook. The Deleted Items folder should now contain the deleted messages, unless Outlook has already deleted them for good by compacting the PST.

I have recovered lost folders and mails using this method several times. I hope you all would be able to recover your lost emails.

I hope you found the information useful and Thank you for reading.