Not a security feature like other excel protection settings, this is just a deterrent, or … continue reading prevent scrolling on excel worksheet To prevent scrolling on excel worksheet, change the scrollarea property for the worksheet, either manually or with a macro.
TURN OFF SCROLL LOCK IN EXCEL 2007 HOW TO
How to lock cells in excel.Ĭlick the view tab on the ribbon. When you are working with a large spreadsheet in microsoft excel, it's easy to find yourself scrolling down or across and losing track of where you are. When working with large excel spreadsheets, the column and row headings located at the top and down the left side of the worksheet disappear if you scroll too far to the right or too far down. More often than not, your worksheet uses only a small percentage of the cells available to you. Locking cells in an excel spreadsheet can prevent any changes from being made to the data or formulas that reside in those particular cells. Cells that are locked and protected can be unlocked at any time by the. Much like num lock and caps lock, the scroll lock feature is a toggle, meaning it can be turned on and off by pressing the scroll lock key. Click start >settings>ease of access>keyboard. If your spreadsheet has multiple columns that require scrolling across the page, locking the first column down can help make sense of all that data. How to turn off scroll lock in excel using a keyboard case study 1:Īfter the format cells window open, press on the protection option, and click on the locked option.
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). However, a neat shortcut is to right click on the area with the tab scrolling arrows. Right click the status bar to display or to hide the scroll lock status. I don't believe what you ask is possible. Freezing locks specific columns or rows in place so that no matter where you scroll they're always visible on the top or side of the sheet. Lock the first column in.įreeze first column of excel. First, we will need to select the cells we want to lock. Select the view tab and navigate to freeze panes. Disable scroll lock in excel using the keyboard if your keyboard has a key labeled as scroll lock or scrlk key, just press it to turn scroll lock off. Look for the check box to the left of the scroll lock. After disabling sticky keys, repeat the instructions in step 1 to ensure scroll lock is actually disabled after you've turned off the sticky keys feature. To keep an area of an excel worksheet visible while you scroll to another area of the worksheet, you can either freeze specific rows or columns in one area to lock them in place or create multiple worksheet areas that can scroll separately from each other by splitting rows and columns.
TURN OFF SCROLL LOCK IN EXCEL 2007 FOR WINDOWS 10
For windows 10 (scroll lock excel) to turn off the scroll lock in excel, follow steps step 1: Press on the format cells option.įreezing rows and columns in microsoft excel versions 2013, 2010, and 2007 can be helpful if you want to keep a section of your spreadsheet visible at all times while you move to and work in. How to customize and use the status bar in excel notice on the above image that “scroll lock” displays in the status bar in excel.Īctually, you can go to the properties box to set the scrollarea to your needed range address.
You should get a new menu with your 3 options. Freezing a column has similar uses in excel.īeing able to lock down your images on a dashboarrd for example to prevent them moving or expanding if you add or delete text, row or columns is essential. Things to remember if we are locking a column by using the freeze panes option, then only the column is locked from scrolling, and the content of the column can always be changed anytime. I didn't know about this trick when i was working in a book with over 270 sheets.ġ.go to the worksheet that you want to lock the screen area. Disabling sticky keys often resolves this issue. Open the worksheet you want to work on.īellow you will find the detailed steps for excel 2016, 2013, 2010 and lower versions. You can choose to only freeze the first visible row in your excel sheet, or freeze multiple rows. If you’re experiencing the scrolling behavior and you don’t see scroll lock on the status bar, it’s. Shortcut keys to lock first columnĪrtificial intelligence masters ArtificialIntelligence in By using the freeze panes, we can lock the first column, any other column, or even the lock the rows and columns of excel. To avoid this problem, freeze the rows and columns.
0 kommentar(er)
