Can't Scroll Down in Large Report

[Houstonwolf]

Hello. I have a perplexing problem with a worksheet I've just spent six hours working on.

I cannot scroll down unless I have a filter selected in one or more columns.

If the auto filter is unselected, I can see the first 42 rows of a 37000-row report. Excel acts as if it is scrolling when I grab the scroll bar or use the scroll wheel on the mouse but the screen doesn't move.

If I add an auto filter I can scroll through the filtered selection.

Because I can see the report through filtering, I know I haven't lost anything and I'm not panicking yet.

My report is due tomorrow. Please help!

 

[mvptomlinson]

Hi Houston,

Are you using Window -> Freeze Panes anywhere in the worksheet (perhaps below the current screen)? Or is Scroll Lock enabled?

If you'd like, try posting the file (minus your data) to a file-sharing site and we can take a look directly.

 

[Houstonwolf]

Hi Houston,

Are you using Window -> Freeze Panes anywhere in the worksheet (perhaps below the current screen)? Or is Scroll Lock enabled?

If you'd like, try posting the file (minus your data) to a file-sharing site and we can take a look directly.

Thanks for replying, Tomlinson. Sorry for the delayed response. I had to get some sleep.

That was exactly it. I had the header (R1) frozen. One I unfroze, the report scrolls as expected.

Lesson learned. Thank you so much!