Double-click the Excel-ScrollLock.applescript file, opening an AppleScript window. Maximum image size is 6Mpixels. When this form is protected and he is viewing it on his office computer, he can use the Tab key to move from one unlocked cell to another. This works in most cases, where the issue is originated due to a system corruption. There’s an easy fix for this. But instead of moving to the next cell, the whole worksheet moved. Making statements based on opinion; back them up with references or personal experience. Clear the Protect Worksheet and Contents of Locked Cells check box. Here's what you need to check: Figure 1. The default is to calculate them automatically, ... Gridlines are very helpful in seeing where cells are located on the screen. You can ... FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. The advanced options of the Excel Options dialog box. try this. How do I lock cells containing formulas but still allow macros to work? How can a hard drive provide a host device with file/directory listings when the drive isn't spinning? He wonders why this is happening; why Excel doesn't behave as it does at the office. Trying to identify a bunch of parts from sets I had as a child 20 years ago. When I select another workbook or another sheet in the original workbook, the tab-key is working again. 1. I already select and activate the original worksheet at the end of the macro, but that doesn't help. Go to the Tools menu, choose Options, then the Transition tab. In Excel 2010 and later versions, display the File tab of the ribbon and then click Options.). Here's the shortcut you need. I do appreciate it. When the Scroll key locks, pressing any arrow key on the keyboard will move the entire worksheet instead of a single cell. My Tab Key Doesn't Work in Word? You’re working in a worksheet in Excel and you press one of the arrow keys on your keyboard to move to the next cell. This solution does not work. It looks like the worksheets loosed the focus, but as soon as I start typing, the content comes in the cell. I already select and activate the original worksheet at the end of the macro, but that doesn't help. When this form is protected and he is viewing it on his office computer, he can use the Tab key to move from one unlocked cell to another. To become a better guitar player or musician, how do you balance your practice/training on lead playing and rhythm playing? This site is for you! Make sure the Transition Navigation Keys check box is unchecked. (When I select another program and return to Excel, that is not enough to get it working again). Using the Office Tab Center. So you can try the following solutions to fix Tab key not working. If you would like to add an image to Unless they are wrong, I guess I'll just have to tell my people to get used to using the arrow keys. The Tab should move to the unlocked cells.>Protect your sheet as normal. Alt Tab Not Working. Learn more about Allen... Want a quick way to repeat a word or phrase you just typed? How does the Dissonant Whispers spell interact with advantage from the halfling's Brave trait? Worksheet tabs in excel are rectangular tabs visible on the bottom left of the excel workbook, the active tab shows the active worksheet available to edit, by default there can be three worksheet tabs opened and we can insert more tabs in the worksheet using the plus button provided to the end of the tabs also we can rename or delete any of the worksheet tabs. Thanks for contributing an answer to Stack Overflow! Check out Excel 2013 For Dummies today! Excel can recalculate your worksheets either automatically or manually.