How to lock screen to prevent scrolling in Excel worksheet?
Normally, you can scroll the scroll bar to any direction of the worksheet, but, sometimes, you need to block scrolling and keep the worksheet screen up to a certain area-A1:M100, for instance. In Excel, how could you finish this job quickly and easily?
This shortcut toggles Scroll Lock on and off. Note: the Scroll Lock status message may or may not be visible on the left side of the status bar, since it can be disabled. See How to disable Scroll Lock for for a full run-down on how to turn off scroll lock if you don't have an extended keyboard. When Scroll Lock is turned on, Excel displays Scroll Lock in the status bar (only if the status bar is customized to display the Scroll Lock status). Right click the status bar to display or to hide the Scroll Lock status. Learn more about keyboard shortcuts Go to Next Chapter: Print. The Scroll Lock setting here doesn't control Scroll Lock, it only displays Scroll Lock status. Once you make sure that the Scroll Lock status is on, look for the Scroll lock message in the lower left. Yes, Scroll Lock is turned on. On a Mac, as far as I know, Scroll Lock status will not appear in the status bar of Excel 2011. (I haven't checked. If 'Scroll Lock' is showing in the bottom-left corner of the Excel window, then YES, scroll lock is enabled. If you do not see 'Scroll Lock,' it is NOT enabled. If you feel that Scroll Lock may be enabled, but you do not see the words in the bottom-left corner, ensure that. Disabling scroll lock on a Mac is just as easy—but only if you have a full-size keyboard. On an extended keyboard, hit the F14 button to turn scroll lock on and off. You may have to hit Shift + F14, depending on your settings.(If that doesn't work, try Command + F14). However, if you're working on a laptop or a smaller keyboard, you don't have an F14 button.
Hp Keyboard Scroll Lock Missing
Lock worksheet screen to prevent scrolling with Kutools for Excel by one click
Lock worksheet screen to prevent scrolling with setting the properties manually
Actually, you can go to the Properties box to set the ScrollArea to your needed range address. Please do as follows:
1. Go to the worksheet that you want to lock the screen area.
2. Then click Developer > Properties, in the Properties dialog box, enter the range address (A1:M100) you need into the ScrollArea text box, see screenshot:
3. Then close the Properties box, and now, you will be restricted to click or scroll to the cells beyond the range you are specified in the Properties dialog.
Notes:
1. The cell address you enter must be a contiguous range.
![For For](https://i.ytimg.com/vi/4tC3hwnw3eM/maxresdefault.jpg)
Unlock Scroll Lock On Laptop
![Mac Mac](https://geekexcel.com/wp-content/uploads/2020/07/toggle-scroll-lock.png)
2. If you want to clear the scroll area lock, you just need to delete the range address from the ScrollArea Properties box in above step 2.
3. This setting will be invalid when you open the workbook next time.
Tips: If the Developer tab is not displayed in your ribbon, you can view this How to show/display developer tab in Excel 2007/2010/2013 Ribbon? article to show it.
Lock worksheet screen to prevent scrolling with VBA code
Here also is a simple code for you to solve this job, please do as follows:
1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module Window.
VBA code: Lock worksheet screen to prevent scrolling
![Scroll Lock In Excel For Mac Scroll Lock In Excel For Mac](https://im.indiatimes.in/content/2017/Nov/excel-content_1510243254.jpg)
3. Then press F5 key to run this code, and your scroll area of the specified sheet and range has been set successfully.
Notes:
1. In the above code, Sheet1 is the worksheet and A1:M100 is the cells range that you want to only be used, you can change them to your need.
2. To cancel the lock of the worksheet screen, please apply following code:
VBA code: Cancel the lock of worksheet screen
Lock worksheet screen to prevent scrolling with Kutools for Excel by one click
If you have Kutools for Excel, with its Set Scroll Area utility, you can quickly lock and hide other direction beyond the selected range with only one click.
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. |
After installing Kutools for Excel, please do as follows:
1. Select the range that you want to use only, and then click Kutools > Show & Hide > Set Scroll Area, see screenshot:
Virtual City Playground for Mac. Virtual City Playground is worth checking out. A 125MB download, the free app allows you to build and run your own cityscape. If world domination is your thing, Virtual City is a great city simulator to get you started. Build your own city and manage it. Jobs are the lynch pin of the economy. The 1.6 version of Virtual City for Mac is provided as a free download on our website. The program belongs to Games. Our antivirus analysis shows that this Mac download is clean. This Mac app was originally produced by G5 Entertainment. Mac virtual camera. Build the city of your dreams and then run it in Virtual City Playground®: Building Tycoon! Build dwellings and industrial buildings. Manufacture a variety of retail goods and deliver them to your sleek and enticing shopping malls. Set up a mass transit system to transport your city dwellers to parks, cinemas, stadiums and more.
2. And only your selected cells can be used, others are hidden and disable to be viewed or edited. See screenshot:
Note: To display other cells, you should click Kutools > Show & Hide > Unhide All Ranges, see screenshot:
Demo: Lock worksheet screen to prevent scrolling with Kutools for Excel by one click
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range..
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
If you are trying to figure out how to unlock scroll lock in Excel, then you are in the right spot. Read along to know more about it!
Microsoft Excel is an excellent productivity tool and forms part of your Microsoft Office Suite. An essential program in your bundled Microsoft Office Suite or a part of the Office 365 Suite, it should be one of the best options for preparing your spreadsheets. However, you may come across a few issues with the program that appears abruptly without any apparent reason.
We will be discussing one such error or issue you would normally face when working with your Excel Workbook. Yes, we are talking about Scroll Lock feature and learn how to disable or turn it off on your Excel program.
Unlock Scroll Lock in Excel O365:
Well, before we begin, it may be apt to understand what exactly is a scroll lock. It is one such issue that if you have not come across at least once, you will not know that it exists. Of course, we would also claim that you may have come across the issue once in a while, but blamed it on the program and have relaunched your Excel program.
Now imagine the situation. You are working on an Excel sheet. There are no issues whatsoever with your formulas and other aspects of your spreadsheet. All of a sudden, you realize that when you tap on the arrow keys, you do not move to the next cell. Instead, the entire workbook or worksheet moves in the direction of the arrow.
Have you come across this issue? We bet you have and have rebooted your Excel program to resolve the issue. However, you are bound to find the issue affecting you quite repeatedly.
Ideally, in an Excel worksheet, pressing the arrow keys moves your cursor from one cell to another in whichever direction you intend it to. However, if you have your Scroll Lock enabled, you will find that the entire worksheet moves when you press the arrow keys. The situation can be alarming if you are not aware of what is happening and why does it happen so. I many cases, users tend to think that their Excel program is broken and needs to be taken care of.
The Excel Scroll Lock is a feature that should help you control how do the arrow keys work in excel concerning the cells in an Excel worksheet. If the Scroll Lock function is disabled, you will find that the arrow keys will help you between the individual cells in any direction. If the Scroll Lock is enabled, you will be able to move your cursor, but the cell selection does not change and remains unaltered. If you have wanted to move to a cell, you need to manually move your cursor to the cell and click there to activate it or make it your active cell.
How to find if the Scroll Lock is enabled?
Before you can check if you can disable the Scroll Lock feature, it would be essential to find if the scroll lock feature is enabled or not on your computer. So, how would you be able to check it?
If you want to check whether the Scroll Lock feature is turned on or off, you just need to have a look at the bottom of your Excel window. Yes, you are right there – it is called Status Bar. The status bar should show whether the scroll lock is applied to your Excel sheet.
In case, you do not see the option for Scroll Lock; your status bar may not have been configured to show it. Right click on the status bar and check the option for Scroll lock. Once that done, the status bar will display if the scroll lock has been enabled or disabled. If you see the words, Scroll Lock, you can be assured that the scroll lock has been activated.
Please note that the scroll lock status will only display the status of scroll lock and will indicate whether it is in the enabled or disabled state. It will not let you control the behavior of your scroll lock. In other words, you cannot disable scroll lock using the status bar.
How to Disable or Unlock Scroll Lock in Excel O365 for Windows?
The NUM Lock and Scroll Lock features work similarly. They work as a toggle. You press them once, they get activated and enable the lock. Tap on them again; they are disabled. You can easily disable the scroll lock using the keyboard and the physical scroll lock key. You will find the scroll lock status disappearing from your status bar on Excel.
However, there are cases where you do not have a scroll lock key on your keyboard. This can be a typical case on the keyboard of a laptop. There are situations where – even when you have a scroll lock key, it may not work.
In such situations, it may be practical to opt for an onscreen keyboard. Windows do come with an on-screen keyboard and can be quite helpful in letting you enable or disable the scroll lock even without the physical key for the scroll lock function.
Go to Windows Search and type in Onscreen Keyboard. Choose the onscreen keyboard from the search results and launch it. You should find the Scroll lock key on the keyboard. Click on it, and you can easily enable or disable the Scroll Lock feature.
Another option to bring up the Onscreen keyboard will involve the following steps –
- Launch your Windows Settings
- Go to Ease of Access grouping.
- Under the Interaction tab on the left side menu bar, locate the Keyboard option.
- Toggle the option for Onscreen keyboard.
Once the onscreen keyboard launches, you are good to go with enabling or disabling your scroll lock on your Excel sheet or for that matter, any of your programs.
How to Disable Scroll Lock on Mac?
Finding if the scroll lock is enabled on Excel is a tough task if you are using Mac. If you want to know whether the scroll lock is turned on, you will need to check it with the behavior of your Excel cells.
Launch your Excel worksheet and press the arrow keys. Observe the behavior of the cells when you press the respective arrow keys. If the cursor moves to the desired cell and turns it active, you can be assured that the scroll lock is not enabled. If it does not move and the cell selection does not change, it should be an indication to show that the scroll lock has been activated.
Now, how to disable the scroll lock on your Mac? Well, there are a few options that should be helpful enough.
Do you have the Apple Extended Keyboard? In that case, it should be easy for you to work with it to disable scroll lock. If you have the F14 key along with Fn key on your keyboard, it should be a more comfortable option to use. The F14 key is the shortcut for scroll lock feature. Make sure you have pressed the Fn key before pressing the F14 key.
If your keyboard does not have the Fn key but features the F14 key, you can press SHIFT key and F14 in combination. Check your keyboard for the exact combinations. You may need to press anyone among Command, Control or Option keys instead of the SHIFT key. The correct option will be dependent upon the configuration on your keyboard.
Yet another good option that can be helpful in case of your Mac is to use the AppleScript feature. AppleScript, if you are not aware, is the built-in scripting language that lets you automate the applications and a few everyday tasks on your Mac. You can make use of the AppleScript to send keystrokes to the app so that it can make changes even without the key being pressed.
You need to know how to use the AppleScript program. It may not be as easy unless you do possess some sort of experience in the programming language.
The following script may be handy enough, though we may not be able to guarantee any assured results –
You may get assistance from anyone who has good experience in programming and in creating scripts.
In Conclusion
![Scroll lock in excel for mac Scroll lock in excel for mac](https://exceljet.net/sites/default/files/styles/original_with_watermark/public/images/articles/inline/mac%20excel%202011%20status%20shows%20no%20scroll%20lock.png?itok=SNQobaZH)
Unlock Scroll Lock On Laptop
2. If you want to clear the scroll area lock, you just need to delete the range address from the ScrollArea Properties box in above step 2.
3. This setting will be invalid when you open the workbook next time.
Tips: If the Developer tab is not displayed in your ribbon, you can view this How to show/display developer tab in Excel 2007/2010/2013 Ribbon? article to show it.
Lock worksheet screen to prevent scrolling with VBA code
Here also is a simple code for you to solve this job, please do as follows:
1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module Window.
VBA code: Lock worksheet screen to prevent scrolling
3. Then press F5 key to run this code, and your scroll area of the specified sheet and range has been set successfully.
Notes:
1. In the above code, Sheet1 is the worksheet and A1:M100 is the cells range that you want to only be used, you can change them to your need.
2. To cancel the lock of the worksheet screen, please apply following code:
VBA code: Cancel the lock of worksheet screen
Lock worksheet screen to prevent scrolling with Kutools for Excel by one click
If you have Kutools for Excel, with its Set Scroll Area utility, you can quickly lock and hide other direction beyond the selected range with only one click.
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. |
After installing Kutools for Excel, please do as follows:
1. Select the range that you want to use only, and then click Kutools > Show & Hide > Set Scroll Area, see screenshot:
Virtual City Playground for Mac. Virtual City Playground is worth checking out. A 125MB download, the free app allows you to build and run your own cityscape. If world domination is your thing, Virtual City is a great city simulator to get you started. Build your own city and manage it. Jobs are the lynch pin of the economy. The 1.6 version of Virtual City for Mac is provided as a free download on our website. The program belongs to Games. Our antivirus analysis shows that this Mac download is clean. This Mac app was originally produced by G5 Entertainment. Mac virtual camera. Build the city of your dreams and then run it in Virtual City Playground®: Building Tycoon! Build dwellings and industrial buildings. Manufacture a variety of retail goods and deliver them to your sleek and enticing shopping malls. Set up a mass transit system to transport your city dwellers to parks, cinemas, stadiums and more.
2. And only your selected cells can be used, others are hidden and disable to be viewed or edited. See screenshot:
Note: To display other cells, you should click Kutools > Show & Hide > Unhide All Ranges, see screenshot:
Demo: Lock worksheet screen to prevent scrolling with Kutools for Excel by one click
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range..
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
If you are trying to figure out how to unlock scroll lock in Excel, then you are in the right spot. Read along to know more about it!
Microsoft Excel is an excellent productivity tool and forms part of your Microsoft Office Suite. An essential program in your bundled Microsoft Office Suite or a part of the Office 365 Suite, it should be one of the best options for preparing your spreadsheets. However, you may come across a few issues with the program that appears abruptly without any apparent reason.
We will be discussing one such error or issue you would normally face when working with your Excel Workbook. Yes, we are talking about Scroll Lock feature and learn how to disable or turn it off on your Excel program.
Unlock Scroll Lock in Excel O365:
Well, before we begin, it may be apt to understand what exactly is a scroll lock. It is one such issue that if you have not come across at least once, you will not know that it exists. Of course, we would also claim that you may have come across the issue once in a while, but blamed it on the program and have relaunched your Excel program.
Now imagine the situation. You are working on an Excel sheet. There are no issues whatsoever with your formulas and other aspects of your spreadsheet. All of a sudden, you realize that when you tap on the arrow keys, you do not move to the next cell. Instead, the entire workbook or worksheet moves in the direction of the arrow.
Have you come across this issue? We bet you have and have rebooted your Excel program to resolve the issue. However, you are bound to find the issue affecting you quite repeatedly.
Ideally, in an Excel worksheet, pressing the arrow keys moves your cursor from one cell to another in whichever direction you intend it to. However, if you have your Scroll Lock enabled, you will find that the entire worksheet moves when you press the arrow keys. The situation can be alarming if you are not aware of what is happening and why does it happen so. I many cases, users tend to think that their Excel program is broken and needs to be taken care of.
The Excel Scroll Lock is a feature that should help you control how do the arrow keys work in excel concerning the cells in an Excel worksheet. If the Scroll Lock function is disabled, you will find that the arrow keys will help you between the individual cells in any direction. If the Scroll Lock is enabled, you will be able to move your cursor, but the cell selection does not change and remains unaltered. If you have wanted to move to a cell, you need to manually move your cursor to the cell and click there to activate it or make it your active cell.
How to find if the Scroll Lock is enabled?
Before you can check if you can disable the Scroll Lock feature, it would be essential to find if the scroll lock feature is enabled or not on your computer. So, how would you be able to check it?
If you want to check whether the Scroll Lock feature is turned on or off, you just need to have a look at the bottom of your Excel window. Yes, you are right there – it is called Status Bar. The status bar should show whether the scroll lock is applied to your Excel sheet.
In case, you do not see the option for Scroll Lock; your status bar may not have been configured to show it. Right click on the status bar and check the option for Scroll lock. Once that done, the status bar will display if the scroll lock has been enabled or disabled. If you see the words, Scroll Lock, you can be assured that the scroll lock has been activated.
Please note that the scroll lock status will only display the status of scroll lock and will indicate whether it is in the enabled or disabled state. It will not let you control the behavior of your scroll lock. In other words, you cannot disable scroll lock using the status bar.
How to Disable or Unlock Scroll Lock in Excel O365 for Windows?
The NUM Lock and Scroll Lock features work similarly. They work as a toggle. You press them once, they get activated and enable the lock. Tap on them again; they are disabled. You can easily disable the scroll lock using the keyboard and the physical scroll lock key. You will find the scroll lock status disappearing from your status bar on Excel.
However, there are cases where you do not have a scroll lock key on your keyboard. This can be a typical case on the keyboard of a laptop. There are situations where – even when you have a scroll lock key, it may not work.
In such situations, it may be practical to opt for an onscreen keyboard. Windows do come with an on-screen keyboard and can be quite helpful in letting you enable or disable the scroll lock even without the physical key for the scroll lock function.
Go to Windows Search and type in Onscreen Keyboard. Choose the onscreen keyboard from the search results and launch it. You should find the Scroll lock key on the keyboard. Click on it, and you can easily enable or disable the Scroll Lock feature.
Another option to bring up the Onscreen keyboard will involve the following steps –
- Launch your Windows Settings
- Go to Ease of Access grouping.
- Under the Interaction tab on the left side menu bar, locate the Keyboard option.
- Toggle the option for Onscreen keyboard.
Once the onscreen keyboard launches, you are good to go with enabling or disabling your scroll lock on your Excel sheet or for that matter, any of your programs.
How to Disable Scroll Lock on Mac?
Finding if the scroll lock is enabled on Excel is a tough task if you are using Mac. If you want to know whether the scroll lock is turned on, you will need to check it with the behavior of your Excel cells.
Launch your Excel worksheet and press the arrow keys. Observe the behavior of the cells when you press the respective arrow keys. If the cursor moves to the desired cell and turns it active, you can be assured that the scroll lock is not enabled. If it does not move and the cell selection does not change, it should be an indication to show that the scroll lock has been activated.
Now, how to disable the scroll lock on your Mac? Well, there are a few options that should be helpful enough.
Do you have the Apple Extended Keyboard? In that case, it should be easy for you to work with it to disable scroll lock. If you have the F14 key along with Fn key on your keyboard, it should be a more comfortable option to use. The F14 key is the shortcut for scroll lock feature. Make sure you have pressed the Fn key before pressing the F14 key.
If your keyboard does not have the Fn key but features the F14 key, you can press SHIFT key and F14 in combination. Check your keyboard for the exact combinations. You may need to press anyone among Command, Control or Option keys instead of the SHIFT key. The correct option will be dependent upon the configuration on your keyboard.
Yet another good option that can be helpful in case of your Mac is to use the AppleScript feature. AppleScript, if you are not aware, is the built-in scripting language that lets you automate the applications and a few everyday tasks on your Mac. You can make use of the AppleScript to send keystrokes to the app so that it can make changes even without the key being pressed.
You need to know how to use the AppleScript program. It may not be as easy unless you do possess some sort of experience in the programming language.
The following script may be handy enough, though we may not be able to guarantee any assured results –
You may get assistance from anyone who has good experience in programming and in creating scripts.
In Conclusion
That was the complete information on how to disable or turn off scroll lock on your Excel program in Office 365 suite. However, do note that the functionality and steps remain the same even when you are facing similar issues on your bundled Microsoft Excel program. Do note that enabling the scroll feature can affect all the programs and applications on your computer and not Excel alone. However, the effects are felt more on Excel, where it touches the functionality to a greater extent.
More on Office 365:
- Disable Scroll Lock – Official Forum