Office Settings & Configuration

Unfreeze Panes in Excel to Bring Columns Into View

Muhammad TalhaMuhammad Talha Nov 14, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

Unfreeze panes to restore horizontal navigation

Remove frozen rows and columns when they leave too little room to navigate the worksheet.

1
Open the View tab

In the affected Excel worksheet, select the View tab on the ribbon.

2
Unfreeze the panes

Select Freeze Panes, then choose Unfreeze Panes.

3
Test scrolling

Use the horizontal scroll bar at the bottom of the worksheet to navigate to the columns you need.

4
Adjust the zoom if needed

Use the zoom control at the bottom of the Excel window to reduce the magnification, then test horizontal scrolling again.

Unfreeze panes to restore horizontal navigation
Keep key columns visible: Frozen panes normally keep selected columns visible while the remaining columns scroll. If you still need that behavior, select a cell to the right of the columns to keep visible, then choose View > Freeze Panes > Freeze Panes.
Free Microsoft Office alternative

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.

Manage frozen panes while navigating wide worksheetsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar ribbon-style interfaceWork with existing Office files in a lightweight suite
microsoft office alternative - wps office

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.