Office Settings & Configuration

Show Gridlines by Default in New Excel Sheets

Algirdas JasaitisAlgirdas Jasaitis Nov 12, 2026 869 views

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

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.

Solution 1Recommended

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.

1
Enable gridlines on the workbook template

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.

2
Save the default workbook template

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.

3
Enable gridlines on a worksheet template

Create or select a correctly configured worksheet, open View > Gridlines, and enable the checkbox if it is not already selected.

4
Save the default worksheet template

Use File > Save As, choose Excel Template (*.xltx), name the file Sheet.xltx, and save it in the same XLStart folder.

5
Restart Excel and test the templates

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.

Template scope matters: Book.xltx controls new workbooks, while Sheet.xltx controls worksheets inserted into existing workbooks. Existing files may retain their own gridline settings.
Free Microsoft Office alternative

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. 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. 2. Show gridlines: Open the View tab and enable Gridlines so the worksheet displays its cell boundaries.
  3. 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.
Quickly control spreadsheet gridlines from the familiar View tabFree and lightweight for creating and editing new spreadsheetsCompatible with Microsoft Excel .xlsx and .xls formatsFamiliar interface helps Excel users migrate with minimal adjustment
QA img-9

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.