When you find your scrollbar isn’t working in Excel, it can be frustrating and obstruct your productivity. Here are 9 ways to troubleshoot and fix the issue:

1. Check Scroll Lock: Make sure the Scroll Lock on your keyboard is not active. You can turn it off by pressing the “Scroll Lock” key (often labeled as “ScrLk”).

2. Enable Scrollbars: Go to File -> Options -> Advanced, and under the “Display options for this workbook” section, make sure to check both “Show horizontal scroll bar” and “Show vertical scroll bar”.

3. Maximize Excel Window: If Excel is not maximized, sometimes, the scrollbars might be hidden. Maximize the window to ensure they appear.

4. Unfreeze Panes: If you’ve previously frozen any panes in your spreadsheet, it could prevent scrolling. Go to the View tab and click “Freeze Panes,” then select “Unfreeze Panes”.

5. Inspect for Split Panes: Similar to frozen panes, split panes may also disrupt scrolling functionality. You can turn this off by going to View -> Split and unchecking if it’s selected.

6. Update Excel: Running an outdated version of Excel can lead to various issues including scrollbar problems. Check for updates through File -> Account -> Update Options -> Update Now.

7. Repair Office Installation: Sometimes a faulty Office installation is the cause which can be fixed through Control Panel -> Programs -> Programs and Features, selecting Microsoft Office, and clicking on “Change” then “Repair”.

8. Check Add-ins: Third-party Add-ins could interfere with Excel’s normal operation. Try running Excel in Safe Mode (hold Ctrl while opening Excel) or go to File -> Options -> Add-ins, and disable each add-in one at a time to find the culprit.

9. Reboot Your System: Switching your computer off and on again may resolve a myriad of software glitches including those that affect Excel’s scrollbars.

By systematically working through these potential fixes, you should be able to restore the scrolling functionality in your Excel worksheets and return to efficient data manipulation.