Fix a Stuck Split View and Missing Column Headers in Excel for Mac
Question details
The user needs to restore missing A, B, and C column headings and remove an apparent split view in a large Excel worksheet on Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- While working in a large Excel worksheet on a Mac, the user sees a split view that seems stuck and the column letter headings are hidden.
- Observed behavior
- The worksheet displays a split or frozen pane that does not close, and column letters A, B, and C are not visible.
Open the affected workbook in Excel for Mac and switch to the View tab. Check that the worksheet is not protected so the Split, Freeze Panes, and View settings can be changed.
Turn Off Freeze Panes and Split in Excel for Mac
Use this first when the worksheet looks stuck in a split or frozen view and the column headings are hidden.
Freeze Panes locks rows or columns on screen, while Split creates separate scrolling panes. If both are active, the window can look stuck and hide context around column headings.
In Excel for Mac, click the View tab in the ribbon at the top of the workbook window.
Click Freeze Panes and choose Unfreeze Panes from the dropdown menu.
In the Window group, click Split to toggle it off if it is highlighted.
If a split bar remains, drag it to the edge or corner of the worksheet window until it disappears.
Show Missing Column Headings in Excel for Mac
Use this if A, B, and C column letters remain hidden after the split and frozen panes are cleared.
Switch to Normal View in Excel for Mac
Use this if the workbook opens in Page Layout or another special view that hides column headings and creates a split-like display.
Open Excel Files and Manage View Settings in WPS Office for Mac
If Excel for Mac continues to show a stuck split view or hidden column headings, try WPS Office for Mac. It opens .xlsx workbooks with full formatting and gives you familiar freeze, split, and heading controls in a free, lightweight interface.

Frequently Asked Questions
Why are columns A, B, and C missing in Excel for Mac?
The column headings are usually hidden by a view setting. Go to Excel > Preferences > View and enable Row & column headers, or switch from Page Layout to Normal view on the View tab.
How do I unfreeze panes in Excel for Mac?
Open the workbook, click the View tab, click Freeze Panes, and select Unfreeze Panes. If rows or columns stay frozen, check whether the sheet is protected.
What is the difference between Freeze Panes and Split in Excel for Mac?
Freeze Panes locks selected rows or columns in place while you scroll. Split creates independent scrollable panes. A stuck split view often means Split is enabled, so click View > Split to toggle it off.
Can WPS Office open an Excel for Mac file with split or frozen panes?
Yes. WPS Spreadsheets for Mac opens .xlsx workbooks and supports Freeze Panes, Split, and heading controls so you can manage the same view settings free.




