Fix Excel Print Settings That Change Unexpectedly
Question details
The user needs Excel to retain the intended print settings for gridlines and row and column headings.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user sets print options across Excel workbooks.
- Observed behavior
- Print Gridlines and Print Row and Column Headings may change unexpectedly across workbooks.
Open an affected workbook and check Page Layout > Sheet Options for the Gridlines and Headings Print checkboxes. Select each affected sheet and check File > Print to confirm which settings appear in print preview.
Update Microsoft Office and check the print settings
Install the latest available Office updates, then verify the settings on affected worksheets.
In Excel, select File > Account > Update Options.
Select Update Now and follow the prompts to install available updates. If update options are unavailable, contact your organization's administrator.
Restart Excel, open an affected workbook, and select each sheet. Under Page Layout > Sheet Options, set the Print checkboxes for Gridlines and Headings as needed.
Select File > Print to check the preview, then save and reopen the workbook to see whether the settings remain as intended.

Test Excel in Safe Mode and check add-ins
Use this Windows test to identify whether an add-in may be changing print settings.
Repair or reinstall Microsoft Office
Try an Office repair if updates and add-in testing do not resolve the issue; reinstall as a last resort.
Manage spreadsheet print settings in WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files in WPS Spreadsheets and review their print settings, making it easy to move your work between office suites.

Frequently Asked Questions
Where do I turn on printed gridlines and headings in Excel?
Select the worksheet, then go to Page Layout > Sheet Options. Under Gridlines and Headings, select the respective Print checkboxes. Use File > Print to preview the result.
Do I need to check print settings on each worksheet?
Yes. Select each affected worksheet and check its Gridlines and Headings Print options under Page Layout > Sheet Options.
How can I tell whether an add-in is causing the changes?
On Windows, start Excel with Windows + R and excel /safe, then test the workbook. If the issue stops, restart Excel normally and use File > Options > Add-ins to disable and test add-ins.
What should I do if Update Options is missing?
Check File > Account for available update controls. If your organization manages Office updates or the controls are unavailable, ask its administrator to check for updates.




