My Excel spreadsheet doesn’t scroll even though I can use the arrows to move around
I was sent a link to an Excel spreadsheet with instructions to look for my name and update the blah blah blah blah. When I opened the spreadsheet, I found that I couldn’t get it to scroll. I could use the arrow keys to move around: The coordinate indicator and the formula bar both updated to reflect where I had gone to, but the window wouldn’t scroll to show the current cell.
Eventually, I figured out what happened.
The panes were frozen.
To unfreeze them, go to the View tab, then open the Freeze Panes menu and select Unfreeze Panes.
What happened is that somebody had used the same menu and selected Freeze Panes while the current cell was somewhere around cell H50. This means that the first seven columns (A through G) and 49 rows (1 through 49) were locked in place, and any scrollable content appeared to the right and below.
They must have done this on a monitor far larger than mine, because my screen wasn’t big enough to show that many rows and columns. All of the scrollable content was being jammed into a region that didn’t even fit on the screen!