{"id":484296,"date":"2022-08-13T21:00:37","date_gmt":"2022-08-13T18:00:37","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-turn-scroll-lock-off-or-on-in-microsoft-excel\/"},"modified":"2022-08-13T21:00:37","modified_gmt":"2022-08-13T18:00:37","slug":"how-to-turn-scroll-lock-off-or-on-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-turn-scroll-lock-off-or-on-in-microsoft-excel\/","title":{"rendered":"#How to Turn Scroll Lock Off (or On) in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a42b701cda6f\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a42b701cda6f\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-turn-scroll-lock-off-or-on-in-microsoft-excel\/#%E2%80%9CHow_to_Turn_Scroll_Lock_Off_or_On_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Turn Scroll Lock Off (or On) in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-turn-scroll-lock-off-or-on-in-microsoft-excel\/#What_Does_Enabling_and_Disabling_Scroll_Lock_Do_in_Excel\" >What Does Enabling and Disabling Scroll Lock Do in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-turn-scroll-lock-off-or-on-in-microsoft-excel\/#Enable_or_Disable_Scroll_Lock_When_Using_Excel\" >Enable or Disable Scroll Lock When Using Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-turn-scroll-lock-off-or-on-in-microsoft-excel\/#Toggle_Scroll_Lock_Without_a_Keyboard\" >Toggle Scroll Lock Without a Keyboard<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Turn_Scroll_Lock_Off_or_On_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Turn Scroll Lock Off (or On) in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<!-- UNCACHED CONTENT --><\/p>\n<figure style=\"width: 1200px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage size-full wp-image-817138\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/scroll-lock-button-black-keyboard.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Closeup of the Scroll Lock button on a black computer keyboard.\" width=\"1200\" height=\"675\"\/><figcaption class=\"wp-caption-text\"><span class=\"type:primaryImage imagecredit\"><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.shutterstock.com\/image-photo\/scroll-lock-key-button-background-texture-1522323092\">xpixel\/Shutterstock.com<\/a><\/span><\/figcaption><\/figure>\n<p>Scroll Lock in Microsoft Excel makes your Up, Down, Right, and Left Arrow keys either move between cells or scroll the entire worksheet. We\u2019ll show you how to switch between these functionalities on your Windows 10 or 11 PC.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>What Are the Sys Rq, Scroll Lock, and Pause Break Keys on My Keyboard?<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"What_Does_Enabling_and_Disabling_Scroll_Lock_Do_in_Excel\"><\/span>What Does Enabling and Disabling Scroll Lock Do in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you disable Scroll Lock and <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/247834\/how-to-fix-arrow-key-scrolling-in-excel\/\">press the arrow keys, Excel lets you move between cells in your spreadsheet. For example, if you press the Down Arrow key, you go down a cell in your worksheet. This is usually the default behavior and allows for quick editing.<\/p>\n<p>If you enable Scroll Lock, on the other hand, Excel lets you scroll your entire worksheet instead of individual cells. For example, if you press the Right Arrow key, your entire worksheet scrolls to the right.<\/p>\n<p>Depending on what feature you feel comfortable using, you can keep Scroll Lock enabled or disabled on your computer.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Fix Arrow Key Scrolling in Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Enable_or_Disable_Scroll_Lock_When_Using_Excel\"><\/span>Enable or Disable Scroll Lock When Using Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One way to toggle Scroll Lock on Windows is to press the dedicated Scroll Lock key on your keyboard. This key is usually located in the top-first row of your keyboard, to the right of the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/211661\/ask-htg-did-the-print-screen-button-ever-literally-print-the-screen-and-can-it-again\/\">Print Screen key.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816703\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/1-scroll-lock-key-on-keyboard.jpg?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Press the Scroll Lock key.\" width=\"614\" height=\"397\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you press the key, you\u2019ll see the Scroll Lock light turn on on your keyboard (if your keyboard has one). This indicates the option is enabled. To turn off Scroll Lock, press the same key again.<\/p>\n<p>On a MacBook, you can use the key combination Fn+Shift+F12 to toggle scroll lock.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Toggle_Scroll_Lock_Without_a_Keyboard\"><\/span>Toggle Scroll Lock Without a Keyboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If your keyboard doesn\u2019t offer a dedicated Scroll Lock key, <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/240288\/how-to-use-the-on-screen-keyboard-on-windows-7-8-and-10\/\">use the on-screen keyboard to enable or disable the feature. Open that keyboard by accessing the \u201cStart\u201d menu, searching for \u201cOn-Screen Keyboard\u201d, and selecting the app in the search results.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816704\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/2-launch-on-screen-keyboard.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Launch On-Screen Keyboard.\" width=\"650\" height=\"313\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you see the virtual keyboard, to activate Scroll Lock, click the ScrLk button. It will turn blue indicating the lock is enabled.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816705\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/3-enable-scroll-lock.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"195\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To deactivate the lock, click the same key again.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816706\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/4-disable-scroll-lock.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the &quot;ScrLk&quot; key.\" width=\"650\" height=\"195\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And that\u2019s all there is to using the Scroll Lock in Microsoft\u2019s spreadsheet program. We hope you find it useful.<\/p>\n<hr\/>\n<p>Did you know you can remap the Scroll Lock button to make it even more useful?<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make Your Scroll Lock Key Useful on a Windows 10 PC<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/816699\/how-to-turn-off-scroll-lock-in-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Turn Scroll Lock Off (or On) in Microsoft Excel&#8221; xpixel\/Shutterstock.com Scroll Lock in Microsoft Excel makes your Up, Down, Right, and Left Arrow keys either move between cells or scroll the entire worksheet. We\u2019ll show you how to switch between these functionalities on your Windows 10 or 11 PC. RELATED: What Are the&#8230;<\/p>\n","protected":false},"author":1,"featured_media":484297,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/scroll-lock-button-black-keyboard.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-484296","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/484296","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=484296"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/484296\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/484297"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=484296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=484296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=484296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}