How to Show Gridlines Automatically in New Excel Workbooks
Question details
The user wants to configure Excel so that gridlines are automatically visible every time a new workbook is created, rather than having to enable them manually for each new sheet.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating new Excel workbooks where default gridlines are missing or invisible.
- Observed behavior
- New Excel worksheets appear completely white because gridlines are either disabled or their color matches the background. Changing the gridline view setting only applies to the current active sheet and does not carry over to future workbooks.
Ensure you have administrator or write permissions to your computer's AppData or Office installation folders, as creating a default template requires saving a file into the system's XLSTART directory.
Create and Save a Default Workbook Template (Book.xltx)
The most effective way to apply gridlines to all future workbooks automatically is by creating a customized default template file and placing it in Excel's startup folder.
Excel uses a default template for all newly created blank workbooks. By saving a custom template named Book.xltx with your preferred gridline settings into the XLSTART folder, Excel will automatically use these settings every time you press Ctrl+N or create a new file.
Open a new, blank workbook in Excel. Navigate to the 'View' tab on the top ribbon and check the 'Gridlines' box in the Show group.
Click 'File' in the top-left corner, select 'Save As', and click 'Browse' to open the file saving window.
In the 'Save as type' dropdown menu, select 'Excel Template (*.xltx)'. The save directory may automatically jump to the Custom Office Templates folder, but you need to change this path.
Navigate to the XLSTART folder. The path is typically 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART'. Name the file exactly 'Book.xltx' and click 'Save'.
Verify and Change Default Gridline Color
If the gridlines are technically enabled but still invisible, their color might be set to white, matching the background of your worksheet.
Manage Worksheets Easily with WPS Spreadsheet
WPS Spreadsheet provides intuitive settings to manage your workspace views. You can easily toggle gridlines and save custom default templates while maintaining complete compatibility with Microsoft Excel.
- 1. Open WPS Spreadsheet: Launch WPS Office on your computer and open a new blank spreadsheet.
- 2. Enable Gridlines: Navigate to the 'View' tab located on the top ribbon and verify that the 'View Gridlines' option is checked.
- 3. Save as a Default Template: Click the 'Menu' button, select 'Save As', choose the template format (.xltx), and save it into your application's startup or template directory to retain these settings for new files.
Frequently Asked Questions
Why did my Excel gridlines disappear suddenly?
Gridlines can disappear if the worksheet cells were filled with a white background color, if the gridline color was accidentally changed to white in the Advanced Options, or if the 'View Gridlines' checkbox in the View tab was toggled off.
Does saving a Book.xltx template affect my existing Excel files?
No, creating or modifying the Book.xltx template only dictates the default formatting for completely new workbooks created from scratch. Your existing files will retain the settings they were originally saved with.
How can I show gridlines on multiple worksheets at once?
You can apply gridline settings in bulk by holding down the Ctrl key and clicking multiple sheet tabs at the bottom to group them. Once they are grouped, go to the View tab and check the 'Gridlines' box to enable them across all selected sheets.
Where can I find the XLSTART folder to save my template?
The XLSTART folder is typically located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART. If you cannot see the AppData folder, you may need to enable 'Hidden items' in the Windows File Explorer View tab.
