Office Settings & Configuration

Fix Vertical Mouse Scrolling Problems in Excel Worksheets with WPS Office Spreadsheets

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 869 views

Question details

The user needs to restore vertical mouse scrolling in certain worksheets of an Excel workbook where horizontal scrolling still works.

Fix Vertical Mouse Scrolling Problems in Excel Worksheets with WPS Office Spreadsheets
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook in WPS Office Spreadsheets

Launch WPS Office, click Menu > Open, and select the Excel workbook that contains the affected worksheets.

2
Select the affected worksheet

Click the sheet tab where vertical mouse scrolling is not working so that you are working on the correct sheet.

3
Unfreeze panes

Go to the View tab, click Freeze Panes, and select Unfreeze Panes. If the option is active, this restores normal scrolling.

4
Unhide hidden rows or columns

Select the rows or columns around the missing area, right-click the row or column header, and choose Unhide.

5
Remove protection from the sheet

Right-click the worksheet tab, select Unprotect Sheet, and enter the password if one has been set.

6
Test vertical scrolling

Try scrolling vertically with the mouse wheel. Save the workbook after scrolling works correctly.

Unfreeze Panes, Unhide Rows, and Remove Sheet Protection in WPS Office Spreadsheets
Scrolling restored: After unfreezing panes and unhiding rows, the affected worksheet should return to normal vertical mouse scrolling.

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. 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, click Menu > Open, and select the Excel workbook with the scrolling problem.
  2. 2. Turn off frozen panes: Select the affected worksheet, click the View tab, open Freeze Panes, and choose Unfreeze Panes.
  3. 3. Unhide any hidden rows or columns: Select the range around the missing rows, right-click the row headers, and choose Unhide.
  4. 4. Remove sheet protection if it restricts scrolling: Right-click the affected sheet tab, choose Unprotect Sheet, and enter the password if prompted.
  5. 5. Test vertical mouse scrolling: Scroll up and down in the worksheet. If it works, save the file as .xlsx to keep the changes.
Restores vertical mouse scrolling without recreating the workbookUnfreezes panes and unhides rows directly in the affected worksheetOpens and saves .xlsx Excel files with full formatting and formula compatibilityProvides a free, lightweight Office interface familiar to Excel users
microsoft office alternative - wps office

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.