Excel 2016 - Cannot type anything into a cell all of a sudden

Anonymous
2017-04-14T07:08:05+00:00

Hi,

I am experiencing a problem with Excel 2016 that is really frustrating.

I am working normally in excel 2016, when all of a sudden I cannot type anything into a cell. If I press Ecs nothing happens. I do not have macros, nor protected sheet or cells. I am working with multiple (2 or more) open excel files at the same time. I tried to figure out, if I press some combination of keys that would cause this, but found nothing. I, however, can move the mouse over the sheet and click different cells. I think the arrow keys work as well.

The strange thing that always "solves" the problem is pressing Enter. Pressing the Enter opens another Excel file that is already opened, and after simply going back to the first one, I then can work on normally. This can occur once, twice but sometimes even 10-times in a single day! Just terrible.

This is time demanding, many times I write into a cell and then see that the cell is still blank, I press the enter to make it work again, going back... - I cannot work like this.

When I was working with the same files in Excel 2013 and 2010 I hadn't have experienced such problems. 

I already read some other forums with people experiencing the same problem, but haven't found any solution yet.

Do you have any?

Thank you!

P.

<Thread has been moved to the correct category by forum moderator>

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

169 answers

Sort by: Most helpful
  1. Anonymous
    2020-08-08T13:39:41+00:00

    The last Windows update has made it worse for me, both in terms of frequency for Excel and Word as well as those annoying distortion bands.... which I don't think are a driver issue since they only affect Excel, Word, and Outlook. This has me seriously looking at other software that is compatible enough for what I need.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-08-08T12:11:32+00:00

    Yep. Same for me. Absolute piece of you-know-what software. Used to be a fantastic program. Worked faultlessly for decades. Not anymore.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2020-08-08T12:09:52+00:00

    I have not yet found one. If I close the computer, go and have a cup of tea. come back and turn it on again, the program will work fine again.... for a while. Just a piece of rubbish software IMHO, just like so much other Microsoft junk.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2020-08-08T08:27:42+00:00

    Where is the solution in this thread?

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2020-08-08T08:24:38+00:00

    I have this exact problem.  Using Excel and then suddenly Excel stops responding.  Scrolling over excel file works.  Switching to another program works but, typing in excel does not work.  The issue will clear itself in a few mins but waiting for this issue to clear several times a day is annoying.

    I have tried all things in this artical but none of fix the issue.

    Was this answer helpful?

    0 comments No comments