Office Settings & Configuration

How to Fix Excel Gridlines Remaining Visible After Being Turned Off

Jason MillerJason Miller Nov 4, 2026 870 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Select the Worksheet

Click on the tab of the specific worksheet where gridlines are still visible.

2
Navigate to the View Tab

Click on the View tab located on the top ribbon menu.

3
Uncheck Gridlines

Locate the Show group and uncheck the Gridlines box. The default background grid should disappear.

Verify Worksheet-Specific View Settings
Apply to All Sheets: To hide gridlines on all sheets at once, right-click any sheet tab, click 'Select All Sheets', and then uncheck the Gridlines option.
Seamless Spreadsheet Management

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. 1. Open Your File: Launch WPS Office and open your spreadsheet file.
  2. 2. Go to the View Tab: Click on the View tab in the top navigation ribbon.
  3. 3. Toggle Gridlines: Locate the View Gridlines checkbox and uncheck it to instantly hide the gridlines across your active sheet.
  4. 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.
100% compatibility with Microsoft Excel (.xlsx, .xls) filesIntuitive View tab for quick and reliable gridline togglingLightweight architecture ensures fast performance even with large datasetsFree to use with a familiar, user-friendly interface
microsoft office alternative - wps office

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.