January 4th, 2022

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!

Author

Raymond has been involved in the evolution of Windows for more than 30 years. In 2003, he began a Web site known as The Old New Thing which has grown in popularity far beyond his wildest imagination, a development which still gives him the heebie-jeebies. The Web site spawned a book, coincidentally also titled The Old New Thing (Addison Wesley 2007). He occasionally appears on the Windows Dev Docs Twitter account to tell stories which convey no useful information.

4 comments

Discussion is closed. Login to edit/delete existing comments.

  • magnum2227 magnum2227

    > Freeze, and put your hands up!
    Shut up and tell me where you stashed the loot!

  • Henke37

    And here I was suspecting that it was the ScrollLock key. Yes, it actually does something in Excel. It’s even remarkably similiar to this other feature.

    • 紅樓鍮

      And the Insert key still does a thing in Word, which would actually be useful if proportional fonts weren’t as popular as they are, and if people still made tables with spaces, and if pressing Backspace recovered the overwritten character.

  • Joshua Hudson

    I wonder if Raymond would still think larger screen if encountering a frozen area somewhere in the thousands of rows.