Fix Cannot Scroll Excel Worksheet Tabs in Microsoft 365
Question details
The user is unable to scroll through worksheet tabs in Microsoft 365 Excel, especially in workbooks containing a large number of sheets.
- Product
- Microsoft 365 Excel
- Device & OS
- not provided
- Scenario
- Attempting to navigate through multiple worksheet tabs in a large workbook after a recent software update.
- Observed behavior
- The sheet-tab scrolling functionality stops working on a specific computer or user profile, although the same Excel build functions normally on other machines.
Before proceeding, check if the tab scroll bar is simply hidden because the horizontal scroll bar was dragged too far to the left, and ensure you have saved your current work.
Use the Activate List and Keyboard Shortcuts
Use built-in navigation shortcuts as an immediate workaround while dealing with a broken or frozen tab scrolling bar.
When dealing with workbooks containing over 100 tabs, manual switching using the broken scroll bar is impossible. Using keyboard shortcuts or the built-in sheet list bypasses the scrolling UI entirely.
Press 'Ctrl + Page Down' to move to the next sheet, or 'Ctrl + Page Up' to move to the previous sheet.
To jump directly to a specific sheet without scrolling, locate the small navigation arrows in the bottom-left corner of the Excel window.
Right-click these navigation arrows to open the 'Activate' dialog box, which displays a vertical list of all your worksheet tabs.
Scroll through the list, select the desired sheet name, and click 'OK' to jump directly to it.
Test on Another Profile or Computer
Determine if the scrolling issue is an isolated bug tied to your specific Windows user profile or device.
Try WPS Office for Smooth Navigation of Large Workbooks
If Microsoft Excel continues to experience scrolling issues with your large workbooks, WPS Office provides a lightweight, highly compatible alternative that handles hundreds of sheets effortlessly. Enjoy seamless navigation and familiar features for free.
- 1. Download WPS Office: Download and install WPS Office for free from the official website.
- 2. Open WPS Spreadsheets: Launch WPS Office and click on 'Spreadsheets' to access the application.
- 3. Open Your Excel File: Click 'Open', select your existing .xlsx workbook, and navigate your tabs without any scrolling issues.

Frequently Asked Questions
Why did my Excel sheet tabs suddenly stop scrolling?
This issue often occurs after a Microsoft Office update that may contain a bug affecting UI elements, or due to a corrupted local Windows user profile. Testing the file on another PC can help isolate the exact cause.
Is there a fast way to jump to a specific tab in Excel without scrolling?
Yes. Right-click the small navigation arrows located in the bottom-left corner of the Excel window. This opens the 'Activate' dialog box where you can scroll through a vertical list and double-click to jump directly to any sheet.
Does the number of tabs affect Excel's scrolling feature?
Yes, workbooks with a massive number of sheets (e.g., over 100) are more prone to displaying UI glitches or memory-related issues in Excel, which can occasionally cause the tab scrolling bar to freeze or become unresponsive.




