Office Settings & Configuration

Fix Excel Checkbox Icon Missing but Still Working

Natalie Taylor Sep 30, 2026 869 views

Question details

The user is experiencing an issue where an Excel checkbox is functional but the visual checkbox icon does not display in the cell.

How to Fix Excel Checkbox Icon Missing but Still Working

Product: Microsoft Excel
Device & OS: Windows
Scenario: Interacting with form controls or checkboxes in an Excel spreadsheet.
Observed behavior: The checkbox functions normally in the background, responding to clicks and the spacebar (returning TRUE/FALSE), but the visual checkbox icon is completely invisible.

Before you start

Before proceeding, ensure you have saved your work and completely closed Microsoft Excel. Because this fix involves the Windows Registry, it is highly recommended to back up your registry before making changes.

Solution 1Recommended

Reset Excel Settings using the Windows Registry

Clearing Excel's configuration data in the Registry can resolve display glitches affecting form controls like checkboxes.

Sometimes, Excel's internal configuration files become corrupted, causing visual anomalies like invisible checkboxes. Deleting the specific Excel registry key forces the application to rebuild its default settings upon the next launch.

Open Registry Editor

Press the Windows key + R to open the Run dialog box. Type 'regedit' and press Enter to launch the Registry Editor.

Navigate to the Office Settings

In the Registry Editor, carefully navigate to the following path: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel (Note: '16.0' corresponds to newer Excel versions like 2016, 2019, 2021, and Microsoft 365).

Rename or Delete the Excel Key

Right-click on the 'Excel' folder. Select 'Rename' and change it to 'Excel_Backup', or select 'Delete' to remove it entirely.

Restart Excel

Close the Registry Editor and open Microsoft Excel. The application will recreate the registry key, which should restore the missing checkbox icons.

Reset Excel Settings using the Windows Registry

Registry Warning: Editing the Windows Registry incorrectly can cause system-wide issues. Always ensure you are modifying the correct path and consider exporting the key as a backup before making changes.

Solution 2

Verify Excel Version and Apply Updates

Ensure your Microsoft Excel is up to date, as known display bugs are often patched in newer releases.

Free Microsoft Office alternative

Use WPS Office to Avoid Registry Hacks and Display Bugs

If Microsoft Excel continues to experience display glitches like missing checkbox icons, consider switching to WPS Office. It provides a highly compatible, lightweight, and stable spreadsheet environment without the need to modify complex system registries.

1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your Windows device.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx file containing the missing checkboxes.
3. View and Interact with Checkboxes: WPS Spreadsheets will seamlessly render your form controls. You can view, click, and interact with your checkboxes without encountering the display errors.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and form controls.Lightweight installation that avoids heavy system registry dependency.Free to use with a familiar, intuitive user interface.Built-in robust form controls and data validation tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel checkbox work but not show the checkmark?

This is typically caused by a visual rendering glitch, a corrupted Excel settings registry key, or outdated graphics drivers. The underlying logic remains intact, which is why it still toggles TRUE/FALSE even when invisible.

Will deleting the Excel registry key delete my files?

No. Deleting the registry key at HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel only resets your user preferences and customized ribbon settings in Excel. It does not affect your saved workbooks or spreadsheet data.

How can I insert a new checkbox in Excel?

To insert a checkbox, you must first enable the Developer tab in Excel options. Then, go to Developer > Insert > Form Controls, click the Checkbox icon, and click anywhere on your sheet to place it.

Does WPS Office support Excel checkboxes?

Yes, WPS Office fully supports Excel form controls, including checkboxes. When you open a Microsoft Excel file in WPS Spreadsheets, your checkboxes and their linked cell functions will work seamlessly.

Office App Problems