Unfreeze Panes in Excel to Bring Columns Into View
Question details
The user needs to bring columns into view when frozen panes make horizontal navigation difficult.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Navigating to hidden or newly unhidden columns in a worksheet with frozen panes.
- Observed behavior
- Frozen columns appear to restrict the space available for horizontal scrolling, making other columns difficult to see.
Open the affected worksheet and check whether columns remain fixed when you scroll horizontally. Note which columns you want to keep visible if you plan to freeze them again.
Unfreeze panes to restore horizontal navigation
Remove frozen rows and columns when they leave too little room to navigate the worksheet.
In the affected Excel worksheet, select the View tab on the ribbon.
Select Freeze Panes, then choose Unfreeze Panes.
Use the horizontal scroll bar at the bottom of the worksheet to navigate to the columns you need.
Use the zoom control at the bottom of the Excel window to reduce the magnification, then test horizontal scrolling again.

Unhide columns that are still missing
Use this if you can scroll normally but some columns remain hidden.
Manage Spreadsheet Panes with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Excel format support make it easy to move existing workbooks into WPS Spreadsheets.

Frequently Asked Questions
Why can't I see some columns when I scroll in Excel?
Frozen columns may occupy much of the visible worksheet, leaving little space for other columns. Select View > Freeze Panes > Unfreeze Panes and test the horizontal scroll bar.
Will unfreezing panes also unhide my columns?
No. Unfreezing removes fixed panes but does not change hidden columns. Select the surrounding column headers, then choose Home > Format > Hide & Unhide > Unhide Columns.
Can I keep my first column visible while scrolling?
Yes. Select View > Freeze Panes > Freeze First Column. The first column stays visible while you scroll through the remaining columns.
How do I freeze several columns without blocking the rest of the sheet?
Select a cell in the top row immediately to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Freeze only the columns you need so there is room to view the rest.




