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.