You can see gridlines in some cells but not others in your Excel worksheet. This creates a confusing, patchy appearance that makes data hard to read. The problem is not broken gridlines but cell formatting that visually overrides them. This article explains the two main causes and provides steps to restore consistent gridlines.
Key Takeaways: Restoring Missing Gridlines
- Home > Font > Fill Color > No Fill: Removes a white cell background that hides gridlines, making them visible again.
- Home > Font > Borders > No Border: Deletes custom border lines that were applied, allowing the default gridlines to show.
- Ctrl + A then Home > Clear > Clear Formats: Resets all cell formatting in the sheet, instantly restoring default gridline visibility.
Why Gridlines Disappear in Some Cells
Excel gridlines are a light gray background guide. They are not part of the cell’s content or permanent formatting. Gridlines disappear when a cell’s formatting layer is placed on top of them. This happens through two common actions.
Applying a white fill color is the most frequent cause. The fill creates a solid white rectangle that covers the gridline. The gridline still exists underneath but is completely hidden. Applying a custom border is the other cause. When you add any border to a cell, Excel removes the default gridline for that cell edge. If you later delete that custom border, the gridline does not automatically return.
Gridlines vs. Borders
It is important to distinguish gridlines from borders. Gridlines are a sheet-level visual aid for all cells. They do not print unless specifically set in Page Layout. Borders are cell-level formatting. They are applied to selected cells and will print by default. A custom border replaces the gridline for that specific cell edge.
Steps to Remove White Fill and Restore Gridlines
Follow these steps if your cells have a white background hiding the gridlines.
- Select the problem cells
Click and drag to select the cells where gridlines are missing. You can select the entire sheet by clicking the triangle at the top-left corner of the grid. - Open the Fill Color menu
Go to the Home tab on the ribbon. In the Font group, click the small arrow next to the paint bucket icon labeled Fill Color. - Choose No Fill
In the color palette that appears, select the option labeled No Fill at the top. This removes any background color from the selected cells. - Verify gridlines are visible
The light gray gridlines should now be visible in the selected cells. The cells will appear with a transparent background.
Steps to Remove Custom Borders and Restore Gridlines
Use this method if cells had borders that were removed, leaving blank edges.
- Select the affected cells
Click and drag to select the range of cells with missing gridlines. Look for cells that may have had borders applied previously. - Open the Borders menu
On the Home tab, find the Font group. Click the small arrow next to the icon that looks like a square divided into four, labeled Borders. - Apply No Border
From the dropdown menu, select the option labeled No Border. This clears any border formatting from the selected cells. - Check the default gridlines
After clearing borders, the default sheet gridlines should become visible again for all edges of the selected cells.
If Gridlines Are Still Missing After Formatting Changes
Gridlines Are Turned Off for the Entire Worksheet
If no cells show gridlines, the sheet view setting may be off. Go to the View tab on the ribbon. In the Show group, ensure the checkbox next to Gridlines is checked. If it is unchecked, gridlines are hidden for the entire active sheet.
Cells Have a Pattern Fill Instead of a Solid Color
A pattern fill can also obscure gridlines. Select the cells and open the Format Cells dialog by pressing Ctrl + 1. Go to the Fill tab. Under Pattern Color, select Automatic. Under Pattern Style, select Solid. Click OK. Then set the Fill Color to No Fill from the Home tab.
The Workbook Uses a Custom Theme or Dark Mode
In Windows 11 with a dark theme, or with a custom Office theme, gridline color may blend with the background. Go to File > Options > General. Under Personalize your copy of Microsoft Office, check the Office Theme. Setting it to Colorful or White often improves gridline contrast.
White Fill vs. No Border: Comparison
| Item | White Fill Problem | No Border Problem |
|---|---|---|
| Primary Cause | Cell background set to white or another solid color | Custom border was applied and then removed |
| Visual Effect | Gridlines are completely hidden behind opaque fill | Gridlines are absent only on cell edges that had a border |
| Quick Fix Tool | Fill Color button on Home tab | Borders button on Home tab |
| Final Action | Select No Fill from color palette | Select No Border from menu |
| Print Behavior | Gridlines print if enabled in Page Layout | Gridlines print if enabled; borders do not return |
You can now fix patchy gridlines by removing white fill or clearing old borders. Use the Clear Formats command for a complete reset on a messy sheet. For more control, explore the Border styles in the Format Cells dialog to apply subtle gray borders that look like gridlines but will print.