Excel Won’t Scroll? ALL 5 Fixes: Step-by-Step (2023)

Scrolling up and down the worksheet is just something we normally do especially when we’re working with a large data set in Excel.

But what do you do when you suddenly can’t seem to scroll in Excel? Even when you tried to scroll with your mouse, touchpad, or keyboard arrow keys, Excel just won’t scroll! 😱

Don’t panic! This problem can be easily fixed πŸ› οΈ

In this tutorial, we’ll cover the reasons why Excel won’t scroll and the possible solutions you can do to get it fixed in no time πŸ˜€

Fix #1: Unfreeze frozen panes

The Freeze panes feature is a useful feature in Excel that allows you to lock specific rows and columns in your worksheet to make it visible while scrolling through the rest of your Excel worksheet.

While it may be such a useful Excel feature, it may be one of the reasons why Excel won’t scroll πŸ₯Ά

The solution to the problem is to unfreeze panes 😊

To unfreeze panes in Excel…

  1. Click the View Tab.
excel wont scroll fix 1 - unfreeze panes
  1. Click the Freeze Panes button.
freeze panes button

The drop-down will show you Freeze panes options.

  1. Select the Unfreeze Panes option from the dropdown.
select unfreeze panes option

That’s it! πŸ‘

Try to scroll down through the spreadsheet with your mouse wheel or touchpad and check if the Unfreeze Panes feature fixed the scrolling issue.

Still can’t scroll? Then maybe it’s not the frozen panes causing it.

Don’t worry, we still have a lot more possible solutions to it 😊

Kasper Langmann, Microsoft Office Specialist

Fix #2: Close any open dialog box

Another thing to consider why Excel won’t scroll is that a dialog box is open.

Say, for example, there’s a Sort dialog box opened somewhere on your screen. When this happens, you can’t scroll in Excel.

The solution? Close any open dialog box or any open windows.

close dialog box or other windows

Once you close any open dialog box, you can return to your worksheet and scroll without any issues.

Fix #3: Restore missing scroll bars

When you open Excel and you can’t see the scroll bars in the window, the Scroll bar options probably aren’t selected.

To restore your missing scroll bars, do the following steps: πŸ‘‡

  1. Go to File Tab.
Restore scroll bars - go to file
  1. Click Options from the left sidebar.
display options
  1. Click the Advanced Tab in the left side panel of Excel options.
  2. Scroll down to find the Display options for this workbook.

Make sure to check the boxes for the βœ… Show horizontal scroll bar and βœ… Show vertical scroll bar.

show vertical scroll bar
  1. Finally, click OK.
click okay to show vertical scroll bar

Ta-da! πŸ˜€ Your Excel vertical scroll bar and horizontal scroll bar are now displayed.

horizontal and vertical scroll bar

Try scrolling up or down your Excel worksheet to see if this fixed your scrolling issue.

Fix #4: Zoom on roll with IntelliMouse

We usually use the mouse scroll wheel to easily scroll up or down our screen.

But if your Microsoft IntelliMouse wheel zooms in πŸ” on a spreadsheet instead of scrolling down it, then that may be the reason why you can’t scroll in Excel.

What you need to do is to disable the Zoom on roll with IntelliMouse option πŸ–±οΈ

  1. Select the File tab in the Excel ribbon.
Go to File tab
  1. Click Options on the left sidebar of Excel.
Excel options
  1. Select the Advanced tab in the Excel options.
  2. Under the Editing Options, deselect the Zoom on roll with IntelliMouse checkbox if selected.
intellimouse option
  1. Lastly, Click OK.
Zoom on roll with IntelliMouse option

When you unchecked this option, you won’t be able to zoom in and out using the mouse wheel.

You can now use it to scroll up and down instead πŸ˜€

Fix #5: CTRL or SHIFT key stuck

If you’re pressing the CTRL key while rolling your mouse wheel, you won’t be able to vertically scroll in Excel.

What this does is Zoom in and out in your Excel spreadsheet πŸ”

If you want to scroll vertically with the mouse wheel, simply release the Ctrl key on your keyboard. Or make sure it isn’t stuck πŸ‘

But maybe it’s not the Ctrl key that was stuck but the Shift key.

If the SHIFT key is stuck, the vertical scroll bar will definitely not work.

Again, simply release the SHIFT key from the stuck and you will be able to scroll vertically 😊

Bonus: What is the Scroll Lock key?

The Scroll lock key is toggling key on your keyboard, just like the Caps Lock and Num Lock. When you toggle Scroll lock, you enable Scroll Lock πŸ”’ and you won’t be able to move between cells using the arrow keys.

Disable the Scroll lock by pressing the Scroll lock key on your keyboard. Learn more about how to fix Scroll Lock here.

That’s it – Now what?

Problem solved! If you ever experience any scrolling issue while working in Excel, you now know how to fix it with the possible solutions we’ve covered above.

Just like the famous quote says: “The solution to a problem lies in the problem itself.”, there’s no Excel issue that Excel can’t solve πŸ‘

Microsoft Excel is a powerful spreadsheet program that allows you to store, organize and calculate data faster and easier for you. It’s only recommended that everyone should get started in Excel.

Learn Excel in the right way and without getting overwhelmed by signing up for my free Excel Beginner Training. Sign up ✍ and learn the basics of Excel quickly, easily, and free!

Other resources

Make your column and row headers visible while you scroll through your spreadsheet by learning how to Freeze Panes in Excel. Read our step-by-step guide about freeze panes here.

Got more questions about Excel? πŸ€”

We’ve compiled the most frequently asked questions we received related to Excel. Find answers to your questions here.

Couldn’t find a solution to your issue? Feel free to contact us. We’re always happy to help 😊