Formatting Issues

Fix Misaligned Row Heights Across Freeze Panes in Excel 2016

Jason MillerJason Miller Nov 20, 2026 869 views

Question details

The user needs to keep rows aligned on both sides of a freeze pane in an older Excel workbook.

Fix Misaligned Row Heights Across Freeze Panes in Excel 2016
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
Working with an older XLS workbook that uses freeze panes.
Observed behavior
Rows appear to have different heights on opposite sides of the freeze pane and become misaligned.
Before you start

Check the workbook's file extension and whether its title bar shows Compatibility Mode. If the workbook contains macros, choose a macro-enabled format when converting it rather than XLSX.

Solution 1Recommended

Convert the XLS workbook to XLSX and reopen it

Use this approach when the affected workbook is in the older XLS format and may be affected by Compatibility Mode.

1
Open Save As

Open the XLS workbook in Excel 2016, then select File > Save As and choose a location.

2
Choose the new format

In Save as type, select Excel Workbook (*.xlsx), enter a name, and click Save. If the workbook contains macros you need to keep, select Excel Macro-Enabled Workbook (*.xlsm) instead.

3
Reopen and test

Close the workbook, open the newly saved file, and check whether rows remain aligned across the freeze pane while you work.

Convert the XLS workbook to XLSX and reopen it
Check the converted workbook: Review the sheets, formulas, and any formatting after conversion. Saving as XLSX resolved the behavior during an initial test in the reported case, but results may vary.
Free Microsoft Office alternative

Work with Frozen Spreadsheet Rows in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files to continue working with frozen rows and columns; WPS does not repair Excel's own display behavior.

Use freeze panes while navigating spreadsheets.Open and save compatible Microsoft Excel XLS and XLSX files.Work in a familiar interface that makes switching from Office easier.Use a free, lightweight office suite for everyday spreadsheet tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why should I convert an XLS file to XLSX?

Older XLS workbooks can open in Compatibility Mode. Saving through File > Save As as an Excel Workbook (*.xlsx) lets you test whether the older format is contributing to the display issue.

Will saving as XLSX preserve macros?

No. If you need to retain macros, select Excel Macro-Enabled Workbook (*.xlsm) in the Save as type list instead of XLSX.

How do I open Excel in Safe Mode?

On Windows, close Excel, press Windows+R, type excel /safe, and select OK. Then use File > Open to test the affected workbook.

Where can I check Excel add-ins?

In Excel, go to File > Options > Add-ins. Choose an add-in type in the Manage box and click Go to view or disable add-ins.