Show Gridlines by Default in New Excel Sheets
Question details
The user needs gridlines to appear automatically in new Excel workbooks, new worksheets, and worksheets added to existing workbooks.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to restore the default worksheet view so newly opened or created sheets display gridlines without manually enabling them each time.
- Observed behavior
- New workbooks and worksheets open with gridlines hidden, even though gridlines are enabled manually on other sheets.
Open a blank workbook and confirm that gridlines are enabled from View > Gridlines. Locate the Excel XLStart folder used by your installation before saving the customized Book.xltx and Sheet.xltx templates.
Save gridline-enabled Excel templates in the XLStart folder
Use this method when new workbooks and newly inserted worksheets should display gridlines automatically.
Excel stores gridlines as worksheet view settings rather than as one global workbook option. Save separate templates for new workbooks and new worksheets so both types inherit the desired view.
Open a blank Excel workbook, select the View tab, and turn on the Gridlines checkbox in the Show group. Configure any other default workbook settings you need.
Choose File > Save As, select Excel Template (*.xltx) as the file type, name the file Book.xltx, and save it in the Excel XLStart folder.
Create or select a correctly configured worksheet, open View > Gridlines, and enable the checkbox if it is not already selected.
Use File > Save As, choose Excel Template (*.xltx), name the file Sheet.xltx, and save it in the same XLStart folder.
Close all Excel windows, reopen Excel, choose File > New > Blank workbook, and insert a new worksheet to confirm that gridlines are visible in both cases.
Check for custom views or macros that hide gridlines
Use this troubleshooting method when the templates are correct but gridlines still disappear in particular workbooks or sheets.
Use WPS Office to keep gridlines visible in new spreadsheets
WPS Office is a free, lightweight Microsoft Office alternative with a familiar spreadsheet interface. Open or create compatible Excel workbooks, use the View tab to control gridlines, and migrate without changing common .xlsx and .xls files.
- 1. Create a spreadsheet in WPS Office: Open WPS Office and select Spreadsheet from the home screen, then create a blank workbook or open an existing Excel file.
- 2. Show gridlines: Open the View tab and enable Gridlines so the worksheet displays its cell boundaries.
- 3. Save the compatible file: Choose Menu > Save As, select Excel 2007-365 Workbook (*.xlsx) or Excel 97-2003 Workbook (*.xls), and save the spreadsheet.

Frequently Asked Questions
Why do gridlines disappear in every new Excel workbook?
Gridlines are saved as worksheet view settings. Create a blank workbook with View > Gridlines enabled, save it as Book.xltx, and place it in Excel's XLStart folder.
How can I show gridlines when adding a new worksheet to an existing workbook?
Enable View > Gridlines on a correctly configured worksheet, save that sheet as Sheet.xltx in the XLStart folder, then restart Excel and insert a new worksheet to test it.
Does enabling gridlines in one Excel sheet change all other sheets?
No. Gridlines are stored separately for each worksheet. You must configure each existing sheet individually or use the Sheet.xltx template for newly inserted worksheets.
What should I check if my Excel template does not restore gridlines?
Confirm that Book.xltx and Sheet.xltx use the Excel Template (*.xltx) format and are saved in the active XLStart folder. Also check Custom Views and VBA code for ActiveWindow.DisplayGridlines = False.
Can a macro hide Excel gridlines after I enable them?
Yes. A workbook or worksheet macro can set ActiveWindow.DisplayGridlines = False. Open the Visual Basic Editor with Alt+F11 and review startup or worksheet event code for that command.




