As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Turn Off Scroll Lock in Excel

If you've encountered slow or cumbersome scrolling in Microsoft Excel, it might be due to the Scroll Lock feature being turned on. Scroll Lock is a toggle, and if it's activated, pressing the arrow keys will scroll the worksheet area instead of moving from cell to cell. Here's how you can turn off Scroll Lock.

Using the Scroll Lock Key:

  1. Locate the Scroll Lock key (usually in the upper-right corner of your keyboard, next to the Print Screen key).
  2. Press the Scroll Lock key (ScrLk) to toggle it off.

Using Excel Ribbon:

  1. Open your Excel workbook.
  2. Go to the "View" tab on the ribbon.
  3. In the "Workbook Views" group, click on "Normal."
  4. Note: If the "View" tab is not visible, make sure your workbook is not in Protected View. If it is, disable Protected View by clicking the "File" tab, then "Info," and finally "Protected View."

Using On-Screen Keyboard:

  1. Click the Start button and type "On-Screen Keyboard" in the search box.
  2. Open the On-Screen Keyboard.
  3. Click the Scroll Lock button on the On-Screen Keyboard.

Using Microsoft Excel Viewer:

  1. Download and install the Microsoft Excel Viewer from the official Microsoft website.
  2. Open your Excel workbook in the Viewer.
  3. Turn off Scroll Lock using the steps mentioned earlier.

Using Google Sheets:

  1. Open the spreadsheet in Google Sheets.
  2. Click on "File" > "Spreadsheet settings."
  3. In the General tab, uncheck the "Lock horizontal scrolling" option.
  4. Click "Save."

If you encounter issues with the Scroll Lock key or it's not available on your keyboard, you can try restarting Excel, checking for a dedicated Scroll Lock key, or using alternative applications like the Microsoft Excel Viewer or Google Sheets. If you have any further questions, feel free to ask!