Excel 2007 Find and Replace Scroll Issues

L

lizstinaff

Spreadsheet: 4.0 MB with 16,000 records and 60 columns created originally in
2003, copied as values into new book and saved as 2007 file (the 2003 version
was 19 MB).

Problem: I am having the same issue with the 2003 and 2007 file.

Here's what happens: I place my cursor on a cell, Ctrl+C and then open Find
and Replace (Ctrl+F) and paste in what I'm looking for (Ctrl+V). I scroll to
the top of the column, click to highlight the entire column and then hit Find
All and then Find Next. Each time I hit Find Next, the cell location area
displays the next occurrence but the page has not jumped to the next
occurrence location. So let's say Find All locates cells A100, A200, A350
and so forth. The page I see is rows 1-43 each time I hit Find Next. The
scroll bar moves and the cell location window displays each occurrence but
the page has not moved. I use the mouse to click on the title bar to switch
from Find/Replace back to the spreadsheet. Since the page did not move to
the next location I use the up and down arrows to find the cursor. Upon
doing this, the information in the cell that I see does not match the
information in the formula bar. Also, when moving the cursor up and down the
Row numbers begin to change. I have found that I am typing over information
I do not want to change. I have to page up and down several times to get the
page to "refresh" and display the correct information.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top