Formatting Issues

How to Change Excel Column Color Without Hiding Gridlines

Maira MehtabMaira Mehtab Oct 28, 2026 871 views

Question details

Applying a fill color to a column hides the default gridlines. The user wants to retain the gridline appearance while highlighting the cells with a background color.

How to Change Excel Column Color Without Hiding Gridlines
Product
Excel
Device & OS
not provided
Scenario
Highlighting a specific column or data range with a background color for better readability without losing the cell dividers.
Observed behavior
The default worksheet gridlines disappear behind the filled cells because fill colors are rendered on top of standard gridlines.
Before you start

Select the entire column or the specific range of cells you wish to colorize before applying any formatting changes.

Solution 1Recommended

Apply Cell Borders to Match Gridlines

The most direct way to restore the appearance of gridlines on colored cells is to manually apply light gray cell borders.

Spreadsheet applications render gridlines behind cell fill colors by default. When you apply a background color, it covers the gridlines. To resolve this, you need to draw borders directly onto the colored cells.

1
Select the Target Range

Highlight the column or the specific cells that you have filled with color.

2
Open the Borders Menu

Navigate to the 'Home' tab on the ribbon and locate the 'Borders' icon in the Font group.

3
Adjust Line Color

Click the drop-down arrow next to the Borders icon, select 'Line Color', and choose a light gray color that mimics standard gridlines.

4
Apply All Borders

Click the Borders drop-down arrow again and select 'All Borders' to apply the lines between every selected cell.

Apply Cell Borders to Match Gridlines
Perfect Match: Choosing a standard light gray (usually the third or fourth shade in the grayscale palette) will make your manual borders indistinguishable from the default worksheet gridlines.
Advanced Formatting

Easily Highlight Cells and Manage Formatting in WPS Spreadsheet

WPS Spreadsheet provides intuitive tools for managing cell styles, borders, and fill colors, making it easy to highlight data exactly how you want while keeping your layout organized.

  1. 1. Open the Document: Open your workbook in WPS Spreadsheet.
  2. 2. Apply Fill Color: Select the column you want to highlight and click the 'Fill Color' icon on the Home tab to choose your background color.
  3. 3. Apply Custom Borders: Click the 'Borders' icon, choose a light gray line color, and select 'All Borders' to instantly restore the gridline appearance.
Quickly apply custom borders to mimic gridlines on colored columns.Create and manage reusable cell styles for consistent formatting across documents.Fully compatible with Microsoft Excel (.xlsx) file formats.Free and lightweight alternative to Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Why do gridlines disappear when I add a fill color?

In spreadsheet software, default gridlines are rendered in the background layer. Adding a solid fill color overlays the gridlines, effectively hiding them. Applying manual cell borders over the fill color is the standard way to resolve this.

How can I change the color of the borders to exactly match default gridlines?

To match default gridlines, open the Borders drop-down menu on the Home tab, select 'Line Color', and choose a light gray shade. The standard light gray in the middle of the grayscale palette usually matches perfectly.

Can I make the cell fill color transparent so gridlines show through?

No, standard cell fill colors in Excel and WPS Spreadsheet are solid and do not have an opacity or transparency setting. You must use cell borders to replicate the look of gridlines on colored cells.