Fix Frozen Rows Blocking Scrolling in Shared Excel Workbooks
Question details
Restore access to cells that are difficult to reach because too many rows appear frozen in a shared Excel workbook.

- Product
- Microsoft Excel for Microsoft 365 Apps for enterprise
- Device & OS
- Desktop app; OS not provided
- Scenario
- Users need to scroll through a protected workbook that is shared for editing.
- Observed behavior
- Excessive frozen rows appear to prevent users from scrolling to required cells.
Check whether you have permission to change the worksheet and, if it is protected, obtain the password from the workbook owner. Coordinate changes to shared settings with other editors.
Reset the frozen pane position
Use this when frozen rows take up too much of the worksheet window.
Open the affected sheet in Excel and select Review. If Unprotect Sheet is available, select it and enter the password if prompted.
Select View > Freeze Panes > Unfreeze Panes, then try scrolling to the required cells.
To keep just the header visible, select View > Freeze Panes > Freeze Top Row. For a custom position, select the cell immediately below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes.
Select Review > Protect Sheet to restore the agreed protection settings, then save the workbook and test scrolling again.

Check filters and reproduce the shared workbook issue
Use this if resetting frozen panes does not resolve the problem or the controls are unavailable.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making it easy to move everyday spreadsheet work. It does not repair Microsoft Excel's shared editing or protection issues.

Frequently Asked Questions
Why can frozen rows make scrolling difficult?
Frozen rows remain visible while you scroll. If many rows are frozen, they can occupy most of the window and leave little room for the scrollable area. Use View > Freeze Panes > Unfreeze Panes to test this.
How do I freeze only the top row in Excel?
Select View > Freeze Panes > Unfreeze Panes if panes are already frozen, then select View > Freeze Panes > Freeze Top Row.
What if I cannot change the frozen panes in a protected sheet?
Ask the workbook owner for permission and the sheet password. If authorized, select Review > Unprotect Sheet, make the change, and restore protection as agreed.
How can I troubleshoot without sharing confidential data?
Create a new workbook through File > New with non-sensitive sample data and reproduce the layout, frozen panes, protection, and sharing setup. Share that test file or screenshots with sensitive information removed.




