Using Shift + F4 key to find Next Occurrence - Excel

Objective:

Using Shift + F4 Key to find next occurance

How is the Question ?

  Step 1.

Use the Find option from the Edit menu as normal, specifying what you want to search for and then looking for the first occurrence.

Step 2

When the first occurrence is displayed,

Press the Esc key (or click on Cancel).

( The Find dialog box disappears.)

Step 3

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.

NCON

Author: NCON

Stay in touch with the latest news and subscribe to the RSS Feed about this category

Comments (0)

Comments are closed


No attachment



You might also like

Shifting and Moving Column and Row by Grabbing

Grabbing the side of a column, or row (#movecol) below the A-B-C column headers, you will see a line...

Continue reading

Excel Shortcuts for Cell Formating

MS Excel Formatting Without The Mouse: I thought today might be a good time for another installment...

Continue reading