Formatting Issues

How to Fix Excel Displaying Green Lines or Missing Gridlines

Amos Gikunda Oct 9, 2026 869 views

Question details

The user is experiencing display glitches where random green lines appear inside cells, and standard gridlines disappear during editing.

How to Fix Excel Displaying Green Lines or Missing Gridlines

Product: Excel
Device & OS: ASUS laptop
Scenario: Editing a workbook where visual glitches obscure the standard cell grid and add unwanted colored lines.
Observed behavior: Unexpected green lines appear inside the cells, and default gridlines randomly disappear, even though the cell text remains fully visible.

Before you start

Before clearing any cell formats, save and back up your current workbook to ensure you do not accidentally lose any critical custom cell styles or data.

Solution 1Recommended

Clear Cell Formatting

Use the Clear Formats feature to remove any corrupted, custom, or hidden border settings causing the green lines.

Often, random lines are the result of unintentional cell formatting or conditional formatting rules applied to the worksheet. Clearing the formats resets the visual layout without deleting your data.

Select the affected cells

Click and drag to highlight the specific cells showing green lines, or press Ctrl + A to select the entire worksheet.

Navigate to the Home tab

Look for the 'Editing' or 'Clear' group located on the right side of the main Home ribbon.

Apply Clear Formats

Click the 'Clear' dropdown menu (typically represented by an eraser icon) and select 'Clear Formats' to reset the cell borders and shading to default.

Data Safety: This action only removes visual formatting. Your actual cell data, text, and formulas will remain fully intact.

Solution 2

Use the Clear All Function

If clearing formats does not resolve the rendering glitch, completely wipe the cell's data and formatting, then re-enter the text.

Solution 3

Check Graphics Display Settings

Display anomalies like missing gridlines on laptops can occasionally stem from graphics driver conflicts or hardware acceleration issues.

Spreadsheet Formatting

Easily Manage Cell Formatting and Gridlines with WPS Spreadsheet

WPS Spreadsheet offers a stable, lightweight environment for all your data tasks. If you encounter persistent display glitches in other software, try opening your file in WPS Spreadsheet to easily reset formats and view your gridlines perfectly.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx workbook.
2. Select the problematic area: Highlight the cells that are showing green lines or missing gridlines.
3. Locate the Clear tool: On the 'Home' tab, find the 'Clear' eraser icon in the toolbar.
4. Clear Formats: Select 'Clear Formats' from the dropdown to instantly reset the visual appearance without losing any data.

Stable rendering engine with no unexpected visual glitchesFully compatible with Microsoft Excel (.xlsx and .xls) formatsLightweight design ensures smooth performance on any laptopFree built-in tools to manage cell styles, formatting, and borders effortlessly

microsoft office alternative - wps office

Frequently Asked Questions

Why do random colored lines appear in my spreadsheet cells?

Random lines, such as green or phantom borders, are often caused by accidentally applied custom cell borders, conflicting conditional formatting rules, or a temporary graphics rendering glitch in the software.

How do I make spreadsheet gridlines visible again?

Navigate to the 'View' tab on the ribbon and ensure the 'Gridlines' checkbox is selected. If they still do not appear, the cells might have a solid white background fill color applied that is hiding the default grid.

Will using 'Clear Formats' delete my formulas?

No, the 'Clear Formats' option only removes visual styling such as font colors, borders, shading, and specific number formats. Your underlying text, data, and mathematical formulas remain completely unaffected.

Document & File Issues