Fix Missing Gridlines in Excel Worksheets and New Workbooks
Question details
The user needs to restore gridlines in Excel worksheets or new workbooks that open without them.

- 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.
Open an affected workbook and select a worksheet where gridlines are missing. Check whether the problem also occurs in a new blank workbook.
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.
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.
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.
In the same worksheet display section, change Gridline color to Automatic or another visible color, then select OK.

Remove cell fills that cover Excel gridlines
Use this method when gridlines are enabled but remain invisible in specific cells.
Test Excel add-ins in Safe Mode
Use this Windows troubleshooting method if gridlines are still missing, including in new blank workbooks.
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.

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.




