Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Excel 2007 Find and Replace Scroll Issues

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Liz Stinaff - 29 Jan 2008 16:06 GMT
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.

Anyone else having the same issue??

Thanks!!  Liz :)
Jim Rech - 30 Jan 2008 16:41 GMT
I could not reproduce this problem.  It does seem to be video driver
related.  Do you have the latest for your card?

Signature

Jim

| Spreadsheet: 4.0 MB with 16,000 records and 60 columns created
| originally in
[quoted text clipped - 37 lines]
|
| Thanks!!  Liz :)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.