Navigating after using find and replace

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

We use Excel to keep track of cost information. It is
helpful to use "find" (Ctl+F) to locate the specific job
number, which may appear many times in a long list of
data. After we find it we typically click on the cell
containing the job number and then use the arrow keys to
go over several columns to check data. Because there are
many rows containing the same job number it gets to be a
real pain having to do this. It would be really nice not
to have to move the cursor over to the cell containing the
job number and clicking on it to be able to use the cursor
or tab after "find" locates it. Isn't there some shortcut
key we could use so we could just tab or arrow over as
each job number is found?
 
Tom,

Instead of using Find, try using Filters instead (Select a single cell in your data table, then use Data | Filter... AutoFilter,
use the drop down that appears to select the job number). If your table is filtered for a specific job, then only those rows will
show, making navigation much easier.

HTH,
Bernie
Excel MVP
 
And if you don't need the data in some of the columns, then hide those columns.

You can always unhide the columns and data|filter|Showall later.
 
Back
Top