Excel scroll lock stuck how to#
Excel scroll lock stuck windows 10#

If you wish to show appreciation for my efforts, mark my post as Accept as Solution. If Row 10 for example, is visible at the top, then it will be locked instead. After that, the top row will not move when you start scrolling down. Then select View > Freeze Panes > Freeze Top Row as shown in the picture below. Hope that answers your question and you have a great day! First, you need to make sure that the row you want to lock is visible at the top. When the on-screen keyboard appears, click the ScrLk button.

Under Search, which will appear as a list above the search box, click the On-Screen Keyboard search result. Turn on/off scroll lock by click Scroll Lock button on the On-Screen Keyboard If there is no Scroll Lock key in your keyboard, you can use this this method. This has occurred with both filters on a single column as well as having filters on all of the columns on the entire sheet. Once in Design mode you should be able to select the scroll bar and hit delete. Begin typing On-Screen Keyboard which will appear in the search entry box. This has been an intermittant problem and the spreadsheet can be copied and pasted over to another blank sheet, if not too humongous and sometimes you have to paste the values and formatting separately but it is a pain. You can first try selecting the scroll bar by using a right click and then once selected you can press delete but you may need to first put the sheet into Design Mode (see the option under the Developer menu in the above image). After that, the content inside the box will be changed. Step 3: Inside the shortcut properties window, click the Shortcut key box and then press Ctrl+Alt+Scroll Lock. Step 2: Right click the shortcut and then choose the Properties option. Tip: To quickly open the On-screen Keyboard in Windows 10, click the Windows button. Step 1: Right click the program that you want to launch quickly and then choose the Create shortcut option. On the right side of the keyboard screen, you will see a key.

Excel scroll lock stuck windows 10#

When the on-screen keyboard appears on your screen, click the ScrLk button. Turn off Scroll lock on Windows 10 Click on the Start menu and search for On-screen Keyboard. If your keyboard does not have a Scroll Lock key, on your computer, click Start > Settings > Ease of Access > Keyboard.Ĭlick the On Screen Keyboard button to turn it on.

Excel scroll lock stuck how to#

I reviewed your post and I understand you want to know how to turn on/off the scroll lock on your computer.ĭon’t worry, I assure you I will try my best to get this sorted. Thank you for posting your query on this forum, it's a great place to find answers.