More than likely the reason is rooted in how Excel is configured. How can a hard drive provide a host device with file/directory listings when the drive isn't spinning? review. Sometimes, it happens that these arrow keys do not work in Excel. Has the European Union taken any concrete steps towards reducing its economic dependency on China? Tab key is not working usually because of the keyboard driver corruption, or the hardware problem. If you would like to add an image to Learn more about Allen... Want a quick way to repeat a word or phrase you just typed? Asking for help, clarification, or responding to other answers. However, Craig noticed that when he is using his home computer the Tab key will not move from one cell to another. Make sure your Scroll Lock is off. If the Alt-Tab function doesn't seem to work with one of them, try the other one! What is this hole above the intake of engines of Mil helicopters? Protect your sheet as normal. Don’t panic. This works in most cases, where the issue is originated due to a system corruption. He is president of Sharon Parq Associates, a computer and publishing services company. :)(Please make sure that Locked checkbox under Format Cells->Protection tab is checked for the cells you want to be locked. This works in most cases, where the issue is originated due to a system corruption. But instead of moving to the next cell, the whole worksheet moved. include the characters [{fig}] in your comment text. You can ... FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. These options are for users coming to Excel from Lotus 123.--Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "S.E." In Star Trek TNG Episode 11 "The Big Goodbye", why would the people inside of the holodeck "vanish" if the program aborts? Can someone be saved if they willingly live in sin? Want to make short work of formatting a large data table? He wonders why this is happening; why Excel doesn't behave as it does at the office. Worksheet Tab in Excel. How to Fix ‘Tab Key not Working’ on Windows? Got a version of Excel that uses the use an earlier version of Excel, visit In the Excel Scroll-lock Fix prompt window, click OK. 1. Stack Overflow for Teams is a private, secure spot for you and You can access Office Tab Center by double clicking on the Office Tab Center icon on your computer desk. There’s an easy fix for this. ", (Your e-mail address is not shared with anyone, ever.). How do I lock cells containing formulas but still allow macros to work? Making statements based on opinion; back them up with references or personal experience. (Make sure you don't confuse the Lotus Compatibility category with the Lotus Compatibility Settings category. Unprotect the sheet.Select all and under Format Cells - Protection, unselect Locked box.Next highlight cells you want locked, Format Cells - Protection, select Locked box.Then go to Review tab, set cells that you want users to edit, and Protect Sheet.Tab key should now tab to only editable cells.Found in Excel Help feature. Display the Excel Options dialog box. (When I select another program and return to Excel, that is not enough to get it working again). Excel can recalculate your worksheets either automatically or manually. If you press the Tab key in Excel, and the cell cursor jumps one screen to the right, then your system is using the navigation emulator instead of the native Excel navigation keys.