Excel shortcuts

3 Ways to Turn Off Scroll Lock in Excel

If you've ever tried to scroll through a worksheet with a lot of data, you know it can be frustrating when you scroll one column over and the whole page moves. That's because the Scroll Lock key on your keyboard is turned on. If Scroll Lock is on, pressing the arrow keys will scroll the worksheet without moving the cell pointer. This can be handy at times, but other times, it's just a pain. Here are three ways to turn off Scroll Lock.

  1. Method 1: Use the Keyboard Shortcut

    To turn off Scroll Lock, press the Scroll Lock key (often labeled as ScrLk) on your keyboard. If your keyboard doesn't have a Scroll Lock key, on your computer, click Start > Settings > Ease of Access > Keyboard, and then turn off the Use the On-Screen Keyboard slider button.

    Method 2: Change the Settings in Excel

    If you don't have a Scroll Lock key on your keyboard (or if you're using a laptop that doesn't have one), you can turn off Scroll Lock in Excel by going to the File tab, and then clicking Options. In the Advanced section, scroll down to the Display options for this workbook section, and then check the Show horizontal scroll bar and Show vertical scroll bar options. Click OK.

    Method 3: Use the Status Bar

    If your computer has a status bar at the bottom of the Excel window, you can quickly tell if Scroll Lock is on or off. If the Scroll Lock status is shown on the status bar, Scroll Lock is on. If the Scroll Lock status is not shown on the status bar, it means Scroll Lock is off.
  2. Now that you know how to turn off Scroll Lock, you can get back to scrolling through your worksheets without issue!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.