In order to not forget what I learn or discover, I write it down … here. Much of the content will be a result of my daily interactions with business users and other BI devs. If the Scroll Lock status is not shown on the status bar, it means Scroll Lock is off.As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later. If the Scroll Lock status is shown on the status bar, Scroll Lock is on. 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.

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. 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. 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 1: Use the Keyboard Shortcut To turn off Scroll Lock, press the Scroll Lock key (often labeled as ScrLk) on your keyboard.

Here are three ways to turn off Scroll Lock. This can be handy at times, but other times, it's just a pain. If Scroll Lock is on, pressing the arrow keys will scroll the worksheet without moving the cell pointer.

That's because the Scroll Lock key on your keyboard is turned on. 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.

Why is there no scroll bar in excel