Printing Problems

Fix Excel Print Settings That Change Unexpectedly

Rana GarciaRana Garcia Nov 20, 2026 869 views

Question details

The user needs Excel to retain the intended print settings for gridlines and row and column headings.

Fix Excel Print Settings That Change Unexpectedly
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.
Before you start

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.

Solution 1Recommended

Update Microsoft Office and check the print settings

Install the latest available Office updates, then verify the settings on affected worksheets.

1
Open update options

In Excel, select File > Account > Update Options.

2
Install updates

Select Update Now and follow the prompts to install available updates. If update options are unavailable, contact your organization's administrator.

3
Check the affected sheets

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.

4
Verify the result

Select File > Print to check the preview, then save and reopen the workbook to see whether the settings remain as intended.

Update Microsoft Office and check the print settings
Known update: The reported issue was addressed in an Office build such as 16.0.10228.20134. Install the latest update available for your Office version.
Free Microsoft Office alternative

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.

Review spreadsheet print settings and preview pages before printingCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.