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.