Try to type–nothing happens. Or hit enter again and the screen changes to an unrelated open Excel document. Same issue here. Not for me but for a user at my company. I will try the temporary solutions that you have provided for now, but a more permanent fix would be nice. The user had Excel 2010 a couple of months ago and did not have this issue.
Why can’t I edit cells in Excel?
This is what is causing the issue with not being able to edit cells. Close the other documents, and re-open your Excel File. This should fix the issue. Close the other Excel files you have open. This is what is causing the issue with not being able to edit cells. Close the other documents, and re-open your Excel File.
You should be asking “How to fix excel not working on Windows 10?”
I found the answer was it was working fine yesterday but now I cant do anything with the rest of the data. A quick fix (not permanent) is to click your start button and in the search bar, type “run” – when it opens, type “excel. exe /safe” and it will open in safe mode. Close it and reopen your normal files.
How do I fix the arrow key not working in Excel?
Arrow keys not working in Excel can be ascribed to the Scroll key locking. When the Scroll key locks, pressing any arrow key on the keyboard will move the entire worksheet instead of a single cell. Therefore, the first fix you can try is disabling Scroll Lock key.
Why won’t my arrow keys scroll through my spreadsheet?
There’s an easy fix for this. When the arrow keys scroll through your entire spreadsheet rather than moving from cell to cell, the culprit of this behavior is the Scroll Lock key. Even if you don’t have a Scroll Lock key on your keyboard (most laptops today don’t), you may have pressed the “Fn” key available on most laptops with another key,.
Working on Excel is necessary when we need to create spreadsheets, crunch numbers, and prepare a business report. We usually press arrow keys to move from one cell to another. But sometimes, the whole sheet is scroll down when you press these keys.
For as long as it remains enabled, the keys won’t do what they’re supposed to do. If you take a look at your keyboard, you’ll find that the light for the scroll lock button is turned on. It indicates the lock is enabled, and you need to turn it off to activate the arrow keys.
Why can’t I enter a transition formula in Excel?
The issue could be because of the following option might enabled in your excel. Please un-check “Transition formula evaluation ” and “Transition formula entry” options under “File > Options > Advanced. These two options available at the bottom of ‘Advanced’ option. Show activity on this post. This happened to me – super frustrating.