{"id":106115,"date":"2022-01-04T07:00:00","date_gmt":"2022-01-04T15:00:00","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/oldnewthing\/?p=106115"},"modified":"2022-01-03T19:49:14","modified_gmt":"2022-01-04T03:49:14","slug":"20220104-00","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/oldnewthing\/20220104-00\/?p=106115","title":{"rendered":"My Excel spreadsheet doesn&#8217;t scroll even though I can use the arrows to move around"},"content":{"rendered":"<p>I was sent a link to an Excel spreadsheet with instructions to look for my name and update the <i>blah blah blah blah<\/i>. When I opened the spreadsheet, I found that I couldn&#8217;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&#8217;t scroll to show the current cell.<\/p>\n<p>Eventually, I figured out what happened.<\/p>\n<p>The panes were <i>frozen<\/i>.<\/p>\n<p>To unfreeze them, go to the <i>View<\/i> tab, then open the <i>Freeze Panes<\/i> menu and select <i>Unfreeze Panes<\/i>.<\/p>\n<p>What happened is that somebody had used the same menu and selected <i>Freeze Panes<\/i> while the current cell was somewhere around cell <i>H50<\/i>. 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.<\/p>\n<p>They must have done this on a monitor far larger than mine, because my screen wasn&#8217;t big enough to show that many rows and columns. All of the scrollable content was being jammed into a region that didn&#8217;t even fit on the screen!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Freeze, and put your hands up!<\/p>\n","protected":false},"author":1069,"featured_media":111744,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[104],"class_list":["post-106115","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oldnewthing","tag-tipssupport"],"acf":[],"blog_post_summary":"<p>Freeze, and put your hands up!<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/posts\/106115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/users\/1069"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/comments?post=106115"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/posts\/106115\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/media\/111744"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/media?parent=106115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/categories?post=106115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/tags?post=106115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}