You probably already know how to look for a particular word or phrase in a Word document or Excel worksheet using the Find feature. You can bring up the Find dialog box either from the Edit menu or you could use the shortcut ‘Ctrl+F’.
There is one thing about Find that could prove to be bothersome. The Find dialog box blocks part of your worksheet. Even when you are stepping through occurrences of a search string using the Find Next button, the Find dialog box continues to block your view.
To overcome this, you can do the following when searching for something:
- Use the Find option from the Edit menu as normal, specifying what you want to search for and then looking for the first occurrence.
- When the first occurrence is displayed, press the Esc key (or click on Cancel). The Find dialog box disappears.
- To find the next occurrence, press Shift+F4.
This procedure works the same as clicking Find Next repeatedly, and it is just as fast, but it gets rid of the annoying Find dialog box.