Fix Excel 2016 When You Cannot Type in Cells
Question details
The user needs to stop Excel 2016 from hanging when text is entered into empty cells.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows
- Scenario
- Entering text into empty cells in an Excel workbook.
- Observed behavior
- Excel hangs during text entry, and the Document Recovery pane appears when the workbook is reopened.
If the Document Recovery pane appears, open the recovered version you need and use File > Save As to save it. Close Excel before testing Safe Mode or repairing Office.
Test Excel in Safe Mode and disable add-ins
Use Safe Mode to check whether an add-in is causing Excel to hang when you type.
Press Windows+R, type excel /safe, and select OK.
Open the affected workbook and try typing in an empty cell. If Excel still hangs, proceed to the Office repair solution.
If typing works in Safe Mode, close Excel and reopen it normally. Go to File > Options > Add-ins, select COM Add-ins in the Manage list, and click Go. Clear the add-in checkboxes and click OK. Repeat with Excel Add-ins in the Manage list.
Close and reopen Excel, then try typing again. If the problem is gone, re-enable add-ins one at a time through File > Options > Add-ins and retest to identify the cause.

Repair the Microsoft Office installation
Use Online Repair if Excel still hangs in Safe Mode or after add-ins are disabled.
Edit Excel Workbooks with WPS Spreadsheets
WPS Office is a free, lightweight, easy-to-use Microsoft Office alternative. Its familiar spreadsheet interface and Excel format compatibility make it easier to move existing workbooks into a different editing environment.

Frequently Asked Questions
How do I start Excel 2016 in Safe Mode?
Press Windows+R, enter excel /safe, and select OK. Then open your workbook and test typing in an empty cell.
What does it mean if typing works in Safe Mode?
An add-in may be causing the hang. Reopen Excel normally, go to File > Options > Add-ins, and disable COM Add-ins and Excel Add-ins using the Manage list and Go button.
What should I do if Excel still hangs in Safe Mode?
Close Excel and go to Control Panel > Programs > Programs and Features. Select Microsoft Office 2016, click Change, and run Online Repair if it is available.
Why does the Document Recovery pane appear?
Excel may show Document Recovery after an unexpected shutdown or interruption. Open the recovered version you need and select File > Save As to save it.




