Why Excel Shows White Dotted Gridlines on Dark Worksheets
Question details
The user wants to fix or remove the white dotted gridlines that persist in Excel when using a custom dark background image, even after configuring a different gridline color.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Customizing a worksheet's appearance by applying a dark PNG image as the background and setting the gridline color to black.
- Observed behavior
- Excel ignores the custom black gridline color and automatically forces white dotted gridlines over the dark image background.
Verify your current Office theme and confirm whether your dark worksheet background is applied as an inserted image or a solid cell fill color, as this dictates how Excel renders the lines.
Use Manual Cell Borders Instead of Default Gridlines
Since default gridlines are hardcoded to invert over image backgrounds, turning them off and applying manual cell borders is the most effective workaround.
Microsoft Excel intentionally renders gridlines as white dotted lines over dark background images to maintain visibility. Because there is currently no built-in setting to disable this specific behavior while retaining standard gridlines, applying manual borders is the recommended alternative.
Navigate to the 'View' tab on the Excel ribbon and uncheck the 'Gridlines' box in the Show group. This removes the white dotted lines entirely.
Highlight the specific cells or the entire worksheet where you want custom lines to appear.
Go to the 'Home' tab, click the arrow next to the 'Borders' icon in the Font group, select 'Line Color', and pick black or your preferred dark color.
Click the 'Borders' dropdown again and select 'All Borders' to draw consistent, solid lines over your dark background.

Use Solid Cell Fill Colors Instead of a Background Image
Replacing your background image with a solid dark cell fill allows Excel to render custom gridline colors correctly.
Submit Feature Feedback to Microsoft
Report this rendering behavior to Microsoft to request future updates that allow customized gridlines over image backgrounds.
Experience Better Formatting Flexibility with WPS Office
If you frequently encounter limitations with Microsoft Office's default rendering behaviors, consider switching to WPS Office. It provides a highly compatible, lightweight, and free alternative with comprehensive worksheet formatting tools to help you design spreadsheets exactly the way you want.
- 1. Download the Software: Visit the official WPS Office website and download the free installation package tailored to your operating system.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open your existing .xlsx or .xls files without losing any of your data.
- 3. Customize Your Workspace: Explore advanced formatting features, apply unique backgrounds, and customize your gridlines with complete creative freedom.

Frequently Asked Questions
Can I force the white dotted gridlines to become solid black?
Currently, Excel does not offer a setting to change the style or color of gridlines once they invert over a dark background image. Applying manual cell borders via the Home tab is the only reliable way to display solid black lines in this scenario.
Does changing the Office theme to Black resolve this issue?
No. Changing the Office theme to Black only darkens the application UI, such as the ribbons, menus, and window frames. It does not alter how gridlines are drawn over custom background images in your worksheet.
Why does Excel invert gridlines over image backgrounds?
Excel automatically calculates contrast when an image is set as the background. To ensure the grid remains visible regardless of the image's color palette, Excel overrides custom gridline colors and applies an inverted dotted line pattern.
How do I completely hide all gridlines in my workbook?
You can quickly remove all default gridlines by navigating to the View tab on the Excel ribbon and unchecking the 'Gridlines' checkbox located in the Show group.




