- #How do i turn off scroll lock in excel how to#
- #How do i turn off scroll lock in excel code#
- #How do i turn off scroll lock in excel windows#
If you don’t have the Scroll Lock key or it does not work for some reason, you can “unlock” Scroll Lock in Excel by using the on-screen keyboard.
#How do i turn off scroll lock in excel how to#
How do I turn Scroll Lock off? How to turn scroll lock on or off in Excel?Ī very easy way to turn on or turn off scroll lock is to press the Scroll Lock button on the keyboard. Thereafter, try scrolling down the spreadsheet.
To unfreeze panes in Excel, select the View tab. In most cases, users can’t scroll down Excel spreadsheets because there are frozen panes within them.How can I fix an Excel file that doesn’t scroll? When the on-screen keyboard appears on your screen, click the ScrLk button.Click the On Screen Keyboard button to turn it on.If your keyboard does not have a Scroll Lock key, on your computer, click Start > Settings > Ease of Access > Keyboard.Right click the status bar to display or to hide the Scroll Lock status.
#How do i turn off scroll lock in excel windows#
Click Start > Settings > Ease of Access > Keyboard > Use the On-Screen Keyboard (or press the Windows logo key + CTRL + O).Press the Scroll Lock key (Scroll Lock or ScrLk) on your keyboard.Right-click anywhere in the bottom menu bar, and then select Scroll Lock from the context menu. Look in the bottom left corner of the Excel window and confirm that Scroll Lock is either turned on or turned off. If you have an extended keyboard with an F14 key, try that first. The official Microsoft shortcut for Scroll Lock is Shift + F14. What is the shortcut key for scroll lock in Excel? How do you enable scroll lock in Excel?.How to turn scroll lock on or off in Excel?.What is the shortcut key for scroll lock in Excel?.Using the developer tab, you can also confirm, remove, and set the scroll area from properties.
Once the macro has run, the user will no longer be able to scroll past the designated cells. This will open a box showing any macros available in the workbook. Sub SetSpecificScrollArea()Ĭlose the visual basics editor and return to the worksheet you wish to apply the scroll lock.įrom the developer tab, select Macros.
#How do i turn off scroll lock in excel code#
Ensure that you have updated the code to lock the screen scroll to the cells you want to be locked. Then copy and paste the code below into the New module box. In the visual basic’s editor, select new from the tab, and then select a new Module. With the developer tab now available, select Visual Basics Editor. In options, select customize ribbon and ensure the developer box is ticked. If the developer tab is not available, we need to turn this on. You can also use VBA to lock the scroll on a worksheet or dashboard. When you return to the workbook the scroll bar will no longer be visible. Untick Show horizontal scroll bar and Show vertical scroll bar and press ok. Scroll down to find Display options for this workbook Using Excel advanced options, it is possible to remove the scroll bars from Excel workbooks. Turning off Vertical and Horizontal scroll bars in Excel Options The user will no longer be able to scroll past the area of the dashboard. Select the first row below the dashboard and then press Ctrl + Shift + Down arrow to select all the rows to the bottom of the sheet. We can also lock the scroll down in the same way. This will hide all columns to the right of the dashboard and the user will no longer be able to scroll further to the right than the dashboard. Then press Ctrl + Shift + Right arrow to select all the cells to the right of the sheet. Start by selecting the first column of blank cells after the dashboard. This way the user cannot ‘lose’ the dashboard because they have scrolled too far, and it will give the dashboard a more app-like feel. However, when you are creating a dashboard or other spreadsheet application, to improve the user experience, it is often a good idea to lock the scroll. Worksheet or workbook protection does not lock the scroll unless you first ensure the cells outside the scroll area are locked and cannot be selected. When you have protected a worksheet and workbook, the user retains the ability to scroll to the far side or bottom of the worksheet. Worksheet Protection to limit the screen scroll area Our Dashboard contains information from cells A1 to U40 and we want to lock the screen so the user is unable to scroll beyond this point. The first using Worksheet protection, the second using advanced excel options, and the third, using VBA. In this article, we will look at 3 ways to set the screen scroll lock area in Excel. Setting the screen scroll lock area improves the user experience and can make a dashboard or other spreadsheet application have more of that App like feel. ****Scroll to the bottom for the video*****
A perfect example would be Excel Dashboards. Often there are times when a spreadsheet developer has the need to set the screen scroll lock area in Excel restricting where the user can scroll and has visibility.
0 kommentar(er)
