Recently I have noticed that in some of my sheets I am unable to type into cells once the mouse cursor is moved away from the cell. For example:
1. I double-click into a cell and can see the typing cursor flashing in it.
2. I type on the keyboard and see the text appearing as you'd expect.
3. Without clicking anything, I move the mouse cursor away from the cell I'm typing in.
4. Keyboard strokes no longer appear in the cell.
Even more noticeably; I can click into a cell, hold a key on the keyboard, see the letters appear in the cell (Eg ffffffffffff) but as soon as I move the cursor out of the cell, the letters stop appearing.
Sounds like no big deal but it's very irritating; when you edit cells, normally you double-click into the cell, click where you want to edit the contents of the cell then move the cursor away so that you can see what you're typing. As soon as I move the cursor away, bam - no more typing allowed...
Any ideas??