August Smart Lock vs Wyze Lock: Which Smart Lock Should You Buy August's smart locks are famous in the market, and it's easy to see why. Mouse Scroll Not Working? Here’s How to Scroll on Chrome, Firefox The mouse is our choice of weapon when we take on the web. If you have any further questions, look at the FAQ section below. That is how you can turn off the scroll lock on Microsoft Excel. Select TurnOffScrollLock, and click Run to run the macro.Īlso Read: How to fix “Microsoft has blocked Macros” error in Excel for Windows Step 6: Press Alt + F8 in Windows, or Option + F8 in Mac. Step 4: Copy and paste the following code into the module: Sub TurnOffScrollLock() Step 2: In the VBA editor, click on the Insert tab and choose Module to insert a new module. Step 1: Use Alt + F11 in Windows, or Option + F11 in Mac to open the VBA editor on Microsoft Excel. Turn Off Scroll Lock Using VBA (Windows)Īlternatively, you can run a macro to turn off the scroll lock. Once you open it, you can use the ScrlLk key to turn it off on Excel.Īlso Read: How to fix Excel not scrolling smoothly on Windows 3. You can search for the same using the search bar. Open the On-Screen Keyboard app from the start menu. This keyboard has the scroll lock key, and you can use it to turn off the scroll lock while Excel is open. Windows has an on-screen keyboard option that provides a virtual set of keys you can use on your display. There is an alternative method to do the same. If you don’t find the Scroll Lock key on your keyboard, don’t worry. Disable Scroll Lock Using On-Screen Keyboard (Windows) On Mac: You can use the key combination fn + Shift + F12 to turn the scroll lock functionality on or off. Therefore, you can use this key to disable the scroll lock on Microsoft Excel. When you use this key, it disables the scroll lock in the open application. If you observe closely, you will notice that your Windows keyboard has a Scroll Lock key. Disable the Scroll Lock Using the Keyboard Shortcut Here are three ways to turn off the scroll lock in Microsoft Excel. Check if it says ‘on’ next to Scroll Lock in the list of options.Įnsure you check the Scroll Lock option on this list so that there’s an indication in the status bar if it is enabled. If you don’t see it, right-click on the status bar. You’ll see an indication that says ‘Scroll Lock’. If you’re unsure whether scroll lock is enabled on Excel, glance at the status bar in the bottom corner of the spreadsheet. Further, the mouse wheel will also scroll the sheet, allowing you to navigate the rows or columns without changing the active cell.Īlso Read: How to move rows and columns in Microsoft Excel How to Check if Scroll Lock Is Enabled on Excel Instead of moving the active cell, the arrow keys will scroll the entire sheet up, down, left, or right. When enabled, you can navigate the spreadsheet without changing the active cell (the currently selected cell). Scroll Lock on Excel affects the way you scroll through a spreadsheet. But what does scroll lock even do on Excel? How do I know if it is turned on? Let’s find out. We’ll also help you reinstate the scroll bar if it is missing from your spreadsheet. In this article, we want to show you how to disable the scroll lock in Microsoft Excel. If you’re in a similar position looking to turn off scroll lock in Excel, we’re here to help. While Microsoft Excel is a powerful tool, understanding its interface and finding various settings and options can be challenging, especially for newcomers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |