How to Fix Excel Allowing Only One Character in a Cell
Question details
The user is unable to type more than a single character into any Excel cell, preventing normal data entry.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Editing cells and entering data in an Excel workbook.
- Observed behavior
- Excel restricts data entry to exactly one character per cell, blocking the user from typing full numbers, formulas, or text strings.
Verify whether this single-character limitation occurs in all Excel workbooks or just one specific file, and check your physical keyboard for any stuck keys before proceeding.
Open Excel in Safe Mode to Isolate Add-ins
Running Excel in Safe Mode bypasses installed extensions, helping you identify if a third-party add-in is causing the single-character limitation.
Conflicting or outdated COM add-ins frequently interfere with normal keyboard inputs in Excel. By launching the application in Safe Mode, you can determine if an add-in is the root cause of the typing restriction.
Press the Windows key + R on your keyboard simultaneously to open the Run dialog box.
Type 'excel /safe' into the text box and press Enter or click OK. Excel will launch with 'Safe Mode' displayed in the title bar.
Try typing a full word into a cell. If you can type normally, go to File > Options > Add-ins. Manage your COM Add-ins and disable them one by one to find and remove the specific add-in causing the issue.

Repair Microsoft Office via Windows Settings
If Safe Mode does not resolve the problem, the core Office installation files might be damaged and require a built-in repair.
Review Data Validation and Cell Protection Settings
Workbook-specific settings can sometimes be configured intentionally or accidentally to restrict cell input length to a single character.
Experience Bug-Free Spreadsheet Editing with WPS Office
If Microsoft Excel continues to restrict your cell inputs or requires lengthy repairs, switch to WPS Office. It provides a lightweight, highly compatible spreadsheet editor that seamlessly opens all your existing Excel files without unexpected typing restrictions.
- 1. Download the software: Visit the WPS Office website and download the free installation package for your operating system.
- 2. Open your Excel files: Right-click any existing .xlsx or .xls file, select 'Open with', and choose WPS Spreadsheets.
- 3. Edit without restrictions: Type and edit your data freely with complete support for your original formulas and formatting.

Frequently Asked Questions
Why is Excel only letting me type one letter per cell?
This glitch is most commonly caused by a conflicting COM add-in interfering with keyboard inputs, corrupted Office installation files, or strict Data Validation rules applied to the worksheet that restrict text length to a single character.
How do I remove text length limits in Excel cells?
To remove length limits, highlight the restricted cells, go to the Data tab on the ribbon, and click Data Validation. Under the Settings tab, change the 'Allow' dropdown to 'Any value', then click OK.
Will repairing Microsoft Office delete my personal Excel files?
No. Running a Quick Repair or Online Repair from the Windows Apps and Features menu only scans and replaces the core application files. It will not delete, move, or alter your personal workbooks and data.




