Home

Excel prevents cell operation

Highlighted
dakotatec
Occasional Visitor

If you want to switch between cells using the cursor keys, or if you want to type in a cell, Excel will not allow it. If you restore all open windows that are open in maximized window mode (ie remove them from maximizing, not minimized), then Excel will be able to operate normally again.

The problem occurs on two different computers with Windows 10 (private) and Windows 7 (office). The problem occurs in Excel 2016, now Office 365. The problem may have been in Excel 2010 as well.

Additional environment conditions: Extended Desktop. Several Excel folders opened; all maximized. The error is reproducible, but occurs intermittently (under not yet comprehensible conditions).

Related Conversations
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
!SPILL error with SUMIFS formula
Dzung Vu in Excel on
18 Replies