Scrolling not working in spreadsheet (Excel 2000)

D

dcg

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
 
D

Dave Peterson

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

dcg

Dave

Thanks for that - worked like a charm.

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

Davi
 
Top