Go to the Developer tab and click on the Visual Basic option to open the visual basic code editor. You can create a VBA script that will remove the scroll lock across all the sheets in your workbook with a single click. You wouldn’t want to do this manually through the Properties menu! Suppose your workbook has a lot of sheets and you want to remove the ScrollArea scroll lock on all the sheets. The ScrollArea setting is a property that you can set with VBA. Use the dropdown in the Properties menu to select each sheet and change this setting. 📝 Note: The ScrollArea property is a sheet level setting, so you might need to remove this range for each sheet in your workbook. When you delete this range and then close the Properties menu, you should be able to scroll around the entire sheet without any issues. Go to the Developer tab and open the Properties menu.ĭelete any range that appears in the ScrollArea input. If this is the case, it’s like the ScrollArea setting in the Properties menu. You will suddenly come up against an invisible border that The scroll bars should now be visible and usable in your workbook! Turn Off Scroll Lock with Properties MenuĪnother scrolling issue you might come across in Excel is that scrolling and the arrow keys may work as expected within a certain range, but nothing outside of this range can be accessed. Press the OK button to close the Excel Options menu.Check both the Show horizontal scroll bar and Show vertical scroll bar options.Scroll down to the Display options for this workbook section.
Go to the Advanced tab in the Excel Options menu.
TURN OFF SMART SCROLL HOW TO
Check out his post for more details on how to open the Excel Options menu. Click on Options at the lower left of the backstage area.If your scroll bars are missing, then you will need to enable them in the Excel Options settings.įollow these steps to enable the scroll bars. If your Excel workbook is missing the horizontal and vertical scroll bars then it’s as though the ability to scroll around your spreadsheet has been locked.
This isn’t a setting to turn on and off the scroll lock, but it might be exactly what you’re looking for. Turn Off Scroll Lock with the Options Menu 💡 Tip: Use the Ctrl + Win + O keyboard shortcut to open the virtual keyboard app. Click on the ScrLk key to turn off the screen lock feature and the blue highlight will be removed. When the screen lock feature is on, it will be highlighted as blue in the app. This will open the On-Screen Keyboard app and you will be able to use the ScrLk key.
TURN OFF SMART SCROLL WINDOWS
Search for the term key in the Windows taskbar search and then click on Open for the On-Screen Keyboard app. If your keyboard doesn’t have a scroll lock key, then you can use the on-screen virtual keyboard in Windows to turn off the scroll lock. Turn Off Scroll Lock with the Windows Virtual Keyboard 📝 Note: Not all keyboards will have a scroll lock key and you will need to use another method. Depending on your keyboard, this might also be labeled as a ScrLk key. Press the Scroll Lock key to turn off the scroll lock feature. Using the keyboard shortcut will also turn off the scroll lock. Using a keyboard shortcut is usually the way this feature gets accidentally turned on. Turn Off Scroll Lock with a Keyboard Shortcut When there is a check next to this option, it will allow the status bar to show you when the scroll lock feature is on.
This can be useful when you want to use the arrow keys to navigate the sheet and don’t want to accidentally change any cell values or formulas while you are scrolling. Scroll lock is a feature that allows you to scroll through your worksheet using the arrow keys without moving the active cell. This post is going to show you how to fix your scrolling problems and turn off the scroll lock feature in Excel. It can be frustrating when your Excel workbook isn’t working normally as expected! This might be something you have accidentally enabled and don’t understand why your Excel is not scrolling normally or why the arrow keys aren’t moving the active cell cursor. Do you want to turn off the scroll lock? This post is going to show you how to disable the scroll lock feature in Excel.
0 kommentar(er)
