Office Settings & Configuration

How to Fix Excel Gray Borders, Hidden Cells, and Incorrect Selection

Kushani NimanthikaKushani Nimanthika Sep 28, 2026 882 views

Question details

The user is experiencing severe graphical glitches in Excel, such as large gray borders, missing worksheet areas, or the mouse selecting different cells from where the pointer is located.

How to Fix Excel Gray Borders, Hidden Cells, and Incorrect Cell Selection
Product
Microsoft Excel
Device & OS
not provided
Scenario
Using Excel for data entry or editing when the user interface glitches and fails to display or select cells correctly.
Observed behavior
Excel displays a large gray border, hides much of the worksheet, or selects cells away from the pointer. This can happen in one specific workbook or globally due to corrupted settings or add-ins.
Before you start

Before proceeding, open a different workbook to test whether the problem is isolated to one specific file or affects the entire Excel application. Save your work and close all active workbooks.

Solution 1Recommended

Disable Add-ins and Run an Office Online Repair

Use this method if the graphical issues are caused by conflicting third-party add-ins or a corrupted Office installation.

Conflicting add-ins are a common cause of interface glitches like inaccurate cell selection or hidden worksheet areas. Disabling them helps isolate the issue. If the problem persists, Microsoft Office's built-in Online Repair tool can replace damaged program files.

1
Disable COM Add-ins

Open Excel and go to File > Options > Add-ins. At the bottom, manage 'COM Add-ins' and click 'Go'. Uncheck all add-ins and click OK, then restart Excel to see if the issue is resolved.

2
Open Windows Control Panel

Press the Windows Key, type 'Control Panel', and open it. Navigate to 'Programs' > 'Programs and Features'.

3
Run Online Repair

Find 'Microsoft Office' in the list of installed applications, right-click it, and select 'Change'. Choose 'Online Repair' (not Quick Repair) and follow the on-screen prompts to reinstall core files.

Disable Add-ins and Run an Office Online Repair
Check Office Version: You can check your current Office version and look for available updates by navigating to File > Account > Update Options > Update Now before attempting a full repair.
Free Microsoft Office alternative

Use WPS Office to Avoid Complex Excel Installation Errors

If Microsoft Excel continues to experience frustrating UI bugs, gray borders, or incorrect cell selections, try WPS Office. It's a lightweight, fully compatible, and free alternative that opens your existing workbooks seamlessly without requiring complex registry fixes or time-consuming repairs.

  1. 1. Download the Installer: Visit the official WPS Office website and download the free installation package.
  2. 2. Install WPS Office: Run the downloaded installer and follow the quick setup wizard to install the software on your computer.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files to continue working immediately without graphical glitches.
Free, lightweight, and fast installation without complex registry issues.Highly compatible with all Microsoft Excel formats including .xlsx, .xls, and .csv.Familiar user interface that requires no learning curve.Built-in tabbed viewing for easier workbook management.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel cell selection not match my mouse pointer?

This offset glitch is usually caused by corrupted display settings, conflicting COM add-ins, or zooming issues. Resetting Excel's view or repairing the Office installation typically resolves the misalignment.

Will resetting the Excel registry delete my spreadsheets?

No. Renaming or resetting the registry keys only clears your customized preferences, recent file lists, and window positions. Your actual workbook files (.xlsx, .csv) remain perfectly safe on your hard drive.

What is the XLSTART folder used for in Excel?

The XLSTART folder stores templates and workbooks that are designed to open automatically every time you launch Excel. If a corrupted file is placed in this folder, it can cause startup display errors or crashing.