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 / September 2005

Tip: Looking for answers? Try searching our database.

Scrolling not working in spreadsheet (Excel 2000)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dcg - 01 Sep 2005 05:56 GMT
Good afternoon.

We have Excel 2000 running on Windows 2000.

I have a spreadsheet with a column that is filtered by Status - Open or
Closed.

If I am showing the 'Open' items, I can page up and down, use the
up/down arrows and the mouse to scroll up and down in the document.

If I show the 'Closed' items, none of the scrolling options work. The
scroll bar on the right indicates that I'm 'moving' down in the
document, and the cell reference in the upper left corner changes (as
does the display of the cell contents) but all I see on the screen is
the first page.

Any thought on what the problem is?

Thanks

David

Signature

dcg

Dave Peterson - 01 Sep 2005 13:07 GMT
Maybe the window|freeze panes was put in the wrong spot.

I'd try window|unfreeze panes.

Then show all the data and reapply that freeze panes where it belongs.

> Good afternoon.
>
[quoted text clipped - 23 lines]
> dcg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26863
> View this thread: http://www.excelforum.com/showthread.php?threadid=401034

Signature

Dave Peterson

dcg - 01 Sep 2005 23:29 GMT
Dave

Thanks for that - worked like a charm.

I don't recall doing a 'pane freeze' but obviously I did.

Davi
 
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.