Software

Ask something
Discussion Locked

Scroll problem in Excel

0 helpful
5 replies

by lreynold

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Excel spreadsheet 10 col by 800 rows that will not scroll down, any ideas?

5 replies

by lo

Might be a bit more specific on ' not scroll down'. Is this with a mouse on the scroll bar, using an arrow key, both?

I had a similar problem at the office. Turned out to be just my stupidity. When I was pressing the down arrow (or up) or using the scroll bar, the screen was scrolling but the cell selection (row/column position) stayed the same.

This turned out to be 'normal' operation when the Scroll Lock key is ON.

by dklippert

Here are some suggestions:

Go to Tools>Unprotect>Worksheet

Go to Windows>Unfreeze Panes

Select the whole worksheet (the gray button to the left of A and above 1) Go to Format>Rows>Unhide.

Make sure Scroll Lock is off.

Use GoTo (F5)to go to an area below what can be displayed and Unhide rows.

This discussion is closed to new replies.