Office Settings & Configuration

Fix Missing Gridlines in Excel Worksheets and New Workbooks

Tauseeq MagsiTauseeq Magsi Nov 20, 2026 869 views

Question details

The user needs to restore gridlines in Excel worksheets or new workbooks that open without them.

Fix Missing Gridlines in Excel Worksheets and New Workbooks
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening a worksheet or creating a new workbook in Excel.
Observed behavior
Worksheet gridlines are not visible by default.
Before you start

Open an affected workbook and select a worksheet where gridlines are missing. Check whether the problem also occurs in a new blank workbook.

Solution 1Recommended

Turn on gridlines and check their display color

Use the worksheet view and display settings to restore gridlines that have been hidden or set to a hard-to-see color.

1
Enable gridlines

Select the affected worksheet, then open View and check Gridlines in the Show group. Alternatively, go to Page Layout > Sheet Options and check View under Gridlines.

2
Check advanced settings

In Excel for Windows, open File > Options > Advanced. Under Display options for this worksheet, select the affected worksheet and make sure Show gridlines is checked.

3
Set a visible color

In the same worksheet display section, change Gridline color to Automatic or another visible color, then select OK.

Turn on gridlines and check their display color
Check each affected sheet: Gridline visibility is a worksheet setting, so repeat these checks on other sheets where gridlines are missing.
Free Microsoft Office alternative

Work with Worksheet Gridlines in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with worksheet gridlines as you move between office suites.

View and edit spreadsheets in a familiar interfaceControl gridline visibility while working on worksheetsCompatible with Microsoft Excel XLS and XLSX formatsFree and lightweight for everyday office work
microsoft office alternative - wps office

Frequently Asked Questions

Why are gridlines missing even though the Gridlines option is checked?

A cell fill can cover gridlines, including a white fill. Select the affected cells and choose Home > Fill Color > No Fill. Also check Home > Conditional Formatting > Manage Rules for rules that apply a fill.

How do I change the gridline color in Excel?

In Excel for Windows, open File > Options > Advanced. Under Display options for this worksheet, select the sheet and set Gridline color to Automatic or another visible color.

Will turning on gridlines make them print?

Not necessarily. To print them, open Page Layout > Sheet Options and check Print under Gridlines.

Why do gridlines appear in Excel Safe Mode?

An add-in may be affecting the normal Excel session. Restart Excel normally, then use File > Options > Add-ins to disable add-ins and test them one at a time.