Navigating after 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 said:
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?
Click to expand...

I may have a couple of suggestions.

First, have you used Window | Freeze panes? Or perhaps Window | Split? If
not, try them out. You can freeze the column(s) on the left containing the
job number, while the columns to the right of the frozen border will scroll
as usual. It's a bit hard to explain, so see Excel help and experiment a
little.

Second, the ctrl-arrow keys will move your cursor large steps at once. The
ctrl-right arrow will move you to the right as far as you have contiguous
data. Ctrl-left arrow will go back. Again, it's easier to experiment than
to describe in words.

I hope this helps.

Dave
dvt at psu dot edu
 
Back
Top