Office Settings & Configuration

Fix Excel Showing Missing Characters While Typing

Huda Qurayshi Oct 10, 2026 871 views

Question details

The user experiences a typing delay where Excel drops characters or stays one keystroke behind until the Spacebar is pressed.

How to Fix Excel Showing Missing Characters While Typing

Product: Microsoft Excel
Device & OS: Windows PC
Scenario: Typing data directly into Excel spreadsheet cells.
Observed behavior: Excel displays one character behind while typing and shows only part of a word until the Spacebar is pressed. The issue is isolated to Excel, while Word and Outlook function normally.

Before you start

Before making changes to system settings or the Windows registry, ensure you have saved all open Excel workbooks and closed the application to prevent data corruption.

Solution 1Recommended

Repair or Reset Microsoft Office Registry Keys

Corrupted background configurations in the Windows Registry can cause keystroke delays. Resetting the Excel registry key often resolves this issue completely.

The Windows Registry stores configuration data for Excel. If these keys become damaged, it can lead to erratic behavior like typing lag or missing characters. Renaming the key forces Excel to build a fresh, uncorrupted configuration upon its next launch.

Close Microsoft Excel

Ensure Excel is completely closed. You can verify this by checking the Task Manager (Ctrl + Shift + Esc) to make sure no Excel background processes are running.

Open the Registry Editor

Press the Windows key + R to open the Run dialog box. Type 'regedit' and press Enter. Click 'Yes' if prompted by User Account Control.

Navigate to the Excel Key

In the Registry Editor, go to the following path: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel (Note: '16.0' corresponds to Office 2016, 2019, and Microsoft 365. If you use an older version, look for 15.0 or 14.0).

Rename the Registry Key

Right-click on the 'Excel' folder in the left pane and select 'Rename'. Change the name to 'Excel.old' and press Enter.

Restart Excel

Close the Registry Editor and open Microsoft Excel. Test your typing to see if the missing characters issue is resolved.

Repair or Reset Microsoft Office Registry Keys

Registry Key Recreated: By renaming the key to Excel.old, you keep a backup of your old settings while allowing Excel to generate a brand new, error-free registry key.

Solution 2

Start Excel in Safe Mode to Check for Add-in Conflicts

Safe Mode launches Excel without any third-party add-ins, helping you determine if an extension is causing the typing delay.

Solution 3

Perform an Online Repair of Microsoft Office

If registry fixes and Safe Mode do not work, an Online Repair will scan and replace any corrupted Microsoft 365 installation files.

Free Microsoft Office alternative

Switch to WPS Office for a Smoother Spreadsheet Experience

If Microsoft Excel continues to experience typing lag, missing characters, or complex registry errors, consider switching to WPS Office. It provides a lightweight, highly responsive spreadsheet tool that avoids the heavy system resource usage and complex registry dependencies of Microsoft 365.

1. Download the Installer: Visit the official WPS Office website and download the free installation file.
2. Install WPS Office: Run the installer and follow the quick setup wizard to install the suite on your PC.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel files to continue working seamlessly.

Highly responsive typing and data entry without frustrating keystroke lagFully compatible with Microsoft Excel formats including .xlsx, .xls, and .csvLightweight software architecture that doesn't bog down your system or rely on fragile registry keysFamiliar user interface ensuring a seamless migration with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel lag and miss characters when I type fast?

Typing lag in Excel is commonly caused by corrupted Windows registry keys, conflicts with outdated third-party add-ins, heavy background processing tasks, or graphics hardware acceleration issues.

Will repairing Microsoft Office delete my Excel files?

No. Running an Online Repair or Quick Repair only replaces and fixes the core application files of Microsoft Office. Your personal spreadsheets, data, and saved documents will remain completely untouched.

How do I permanently disable add-ins if Safe Mode fixes the typing issue?

To disable add-ins, open Excel normally and go to File > Options > Add-ins. At the bottom, select 'COM Add-ins' from the Manage drop-down menu and click 'Go'. Uncheck the boxes next to the add-ins you want to disable and click OK.

Office App Problems