Today you’ll learn the shortcut that repeats the last Find action without opening up the Find Dialog Box. This shortcut saves you time and keeps you in your workbook. It’s especially useful when you are fine tuning and editing a bunch of data.
Example: You’ve just followed the “How to find things in a Microsoft Excel Spreadsheet” blog post and the last thing you searched for was your name. The search comes up empty and you continue with your work. At the end of your work session you want to search one more time for your name, just to ensure it is nowhere to be found in your workbook. Instead of opening up the Find Dialog Box all you have to do is execute a one-modifier key shortcut.
The Find Next shortcut:
As you keep executing the shortcut Excel keeps cycling through the workbook to find all instances of the last searched text. If there are no instances of the last searched text this dialog box will pop up telling you so.
And there you have it. The simple Find Next shortcut that can save you time by not opening the Find dialog box, and by not having to type what you are searching for over again.
Comments will be approved before showing up.