Fix Misaligned Row Heights Across Freeze Panes in Excel 2016
Question details
The user needs to keep rows aligned on both sides of a freeze pane in an older Excel workbook.

- 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.
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.
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.
Open the XLS workbook in Excel 2016, then select File > Save As and choose a location.
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.
Close the workbook, open the newly saved file, and check whether rows remain aligned across the freeze pane while you work.

Test Excel in Safe Mode to check for add-in conflicts
On Windows, use Safe Mode if the issue continues after converting the workbook.
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.

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.




