How to Fix Excel Gridlines Remaining Visible After Being Turned Off
Question details
The user is unable to hide gridlines in a specific Excel worksheet using the standard View settings.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to hide gridlines in a new or existing worksheet for a cleaner presentation, but the standard toggle does not work.
- Observed behavior
- Gridlines stay visible despite clearing the Gridlines checkbox under the View tab, though changing the gridline color temporarily masks them.
Ensure you are trying to hide default gridlines and not cell borders, as manually applied cell borders are formatted separately and cannot be hidden via the View tab.
Verify Worksheet-Specific View Settings
Gridline settings apply to individual worksheets, not the whole workbook. You must disable them on the specific sheet.
A common misconception is that toggling gridlines affects the entire workbook. If you have multiple sheets, you must turn off the gridlines for each active worksheet individually.
Click on the tab of the specific worksheet where gridlines are still visible.
Click on the View tab located on the top ribbon menu.
Locate the Show group and uncheck the Gridlines box. The default background grid should disappear.

Remove Applied Cell Borders
What appears to be persistent gridlines might actually be thin cell borders applied to the data range.
Copy Data to a Fresh Worksheet
If legacy settings or workbook corruption cause persistent gridlines, migrating to a clean sheet will resolve the formatting bug.
Easily Manage Gridlines and Formatting with WPS Office
WPS Spreadsheet offers an intuitive and glitch-free interface for managing worksheet views. You can easily toggle gridlines, customize borders, and format your data with just a few clicks.
- 1. Open Your File: Launch WPS Office and open your spreadsheet file.
- 2. Go to the View Tab: Click on the View tab in the top navigation ribbon.
- 3. Toggle Gridlines: Locate the View Gridlines checkbox and uncheck it to instantly hide the gridlines across your active sheet.
- 4. Manage Borders: If any lines remain, easily clear them by selecting the cells, going to the Home tab, and choosing 'No Border' from the borders menu.

Frequently Asked Questions
Why are gridlines printing even when they are hidden on the screen?
Print settings are managed separately from view settings. To stop gridlines from printing, go to the Page Layout tab, locate the Sheet Options group, and uncheck the Print box under the Gridlines section.
Can I hide gridlines across multiple worksheets at once?
Yes. Right-click any worksheet tab at the bottom of the screen and choose 'Select All Sheets'. Then, go to the View tab and uncheck Gridlines. This will apply the setting to all grouped worksheets simultaneously.
How do I change the gridline color if I don't want to hide them completely?
You can customize the color by navigating to File > Options > Advanced. Scroll down to the 'Display options for this worksheet' section, click the Gridline color dropdown, and choose your preferred color.




