Fix Vertical Mouse Scrolling Problems in Excel Worksheets with WPS Office Spreadsheets
Question details
The user needs to restore vertical mouse scrolling in certain worksheets of an Excel workbook where horizontal scrolling still works.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with an Excel workbook containing multiple worksheets, but only some worksheets no longer scroll vertically with the mouse.
- Observed behavior
- Vertical mouse scrolling stops working on some worksheets while horizontal scrolling still works.
Save a copy of the workbook, then open it in WPS Office Spreadsheets. Make sure the affected worksheet is the active sheet and that you can access the View tab and the sheet tab right-click menu.
Unfreeze Panes, Unhide Rows, and Remove Sheet Protection in WPS Office Spreadsheets
Use this solution when only some worksheets in a workbook fail to scroll vertically while horizontal scrolling still works, because frozen panes, hidden rows, and sheet protection are the most common per-sheet causes.
Scrolling behavior can be set per worksheet. Frozen panes lock visible rows or columns, hidden rows create large invisible areas, and protected sheets can restrict navigation. Each setting must be checked on the affected sheet, not on the whole workbook.
Launch WPS Office, click Menu > Open, and select the Excel workbook that contains the affected worksheets.
Click the sheet tab where vertical mouse scrolling is not working so that you are working on the correct sheet.
Go to the View tab, click Freeze Panes, and select Unfreeze Panes. If the option is active, this restores normal scrolling.
Select the rows or columns around the missing area, right-click the row or column header, and choose Unhide.
Right-click the worksheet tab, select Unprotect Sheet, and enter the password if one has been set.
Try scrolling vertically with the mouse wheel. Save the workbook after scrolling works correctly.

Fix Excel Vertical Scrolling Issues Directly in WPS Office Spreadsheets
Open the affected Excel workbook in WPS Office Spreadsheets and restore vertical scrolling by turning off frozen panes, unhiding rows or columns, and removing sheet protection on the individual worksheets.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, click Menu > Open, and select the Excel workbook with the scrolling problem.
- 2. Turn off frozen panes: Select the affected worksheet, click the View tab, open Freeze Panes, and choose Unfreeze Panes.
- 3. Unhide any hidden rows or columns: Select the range around the missing rows, right-click the row headers, and choose Unhide.
- 4. Remove sheet protection if it restricts scrolling: Right-click the affected sheet tab, choose Unprotect Sheet, and enter the password if prompted.
- 5. Test vertical mouse scrolling: Scroll up and down in the worksheet. If it works, save the file as .xlsx to keep the changes.

Frequently Asked Questions
Why does vertical scrolling work in some Excel sheets but not others?
Worksheet settings such as frozen panes, hidden rows, hidden columns, sheet protection, or scroll area restrictions are stored per sheet. The affected sheet may have a setting that the other sheets do not.
How do I unfreeze panes in WPS Office Spreadsheets?
Select the affected worksheet, go to the View tab, click Freeze Panes, and then select Unfreeze Panes.
Can WPS Office open and fix an Excel workbook without Microsoft Excel?
Yes. WPS Office Spreadsheets can open .xlsx and .xls workbooks, and you can change freeze panes, hidden rows, and sheet protection directly in WPS Office.
Will removing sheet protection change my worksheet data?
No. Removing sheet protection only unlocks editing or navigation restrictions. It does not change cell values or formulas, but you may need the password if one was set.
What should I do if the sheet still does not scroll vertically after unfreezing and unhiding?
Check whether the sheet has a large hidden area or a restricted scroll area. You can also open the workbook in WPS Office Spreadsheets to rule out Excel add-ins or macros that may be interfering with scrolling.




