How to Change Excel Column Color Without Hiding Gridlines
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.

- 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.
Select the entire column or the specific range of cells you wish to colorize before applying any formatting changes.
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.
Highlight the column or the specific cells that you have filled with color.
Navigate to the 'Home' tab on the ribbon and locate the 'Borders' icon in the Font group.
Click the drop-down arrow next to the Borders icon, select 'Line Color', and choose a light gray color that mimics standard gridlines.
Click the Borders drop-down arrow again and select 'All Borders' to apply the lines between every selected cell.

Create a Reusable Cell Style with Fill and Borders
If you frequently need to highlight columns without losing gridlines, save the formatting as a custom cell style to apply it in one click.
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. Open the Document: Open your workbook in WPS Spreadsheet.
- 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. Apply Custom Borders: Click the 'Borders' icon, choose a light gray line color, and select 'All Borders' to instantly restore the gridline appearance.

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.




