Are you having trouble scrolling in Microsoft Excel There are 8 ways to fix it

Have you had trouble scrolling through? Excel spreadsheets Are you having problems with your touchpad, keyboard, or mouse? Are there any specific pages affected by the problem? Does the scroll bar not appear on your worksheet?

This tutorial will show you how to fix scrolling problems in Excel, both on Windows and Mac.

1. Panes that have been frozen

Your spreadsheet may have the first row, or column, frozen. This happens if your scrolling is slow. You can release the frozen panes by following these steps.

Windows: Unfreeze Excel Panes

1. Open Excel’s View tab.

2. Select the freeze panes option from the drop-down menu Unfreeze Panes.

You can scroll the spreadsheet using your mouse wheel, touchpad or keyboard to check whether the “Unfreeze Panes feature” fixed the issue.

In macOS, unfreeze Excel Panes

Open Excel’s View Select the tab and click on Window Select from the drop-down menu Unfreeze Panes.

2. The Scroll Bar can be re-enabled

For easy navigation, Excel spreadsheets have both a vertical and horizontal scroll bar. Follow the below steps to add scroll bars to your Excel spreadsheet. Re-enabling the scroll bars may fix an issue if they aren’t working or have become frozen.

1. Open Excel’s File tab.

2. Select More Use the sidebar to select Options.

3. Select Advanced Scroll down to the section “Display options of this workbook”, located in the sidebar. Click the boxes next to Show horizontal scroll bar and Show vertical scroll bar.
4. Select OK To save your changes, close the Excel Options window.

3. Deactivate Scroll Lock

Scroll Lock will disable your computer’s ability to use the arrow keys. Scroll Lock is disabled if you have a scroll lock enabled Excel spreadsheets cannot be scrolled using the arrow keys, Scroll Lock can be disabled and you will need to try it again.

Excel’s built-in scroll lock can be disabled

1. Right-click at the bottom of the worksheet to display the status bar.

2. Scroll Lock can be disabled by clicking on the checkmark beside it.

You can disable scroll lock on your keyboard

You will find a key that says “Scroll Lock”, or “ScrLk”) on the keyboard. Press the button if the indicator or key is illuminated Scroll Lock To turn the feature off and to enable your arrow keys, press this key.

Scroll lock via the on-screen keyboard can be disabled

Scroll lock can be also disabled using your on-screen keyboard.

Use the Windows key + Ctrl + O Use keyboard shortcuts turn on Windows On-Screen keyboard.

Alternatively, go to Settings > Accessibility > Keyboard Turn on the toggle On-screen keyboard.

In Windows 10, go to Settings > Ease of Access > Keyboard Click on the toggle button Use the On-Screen Keyboard.

Scroll lock is activated if “ScrLk”, the key with a blue background, has been pressed. Deactivate the ScrLk key To disable Scroll Lock. Now you should be able scroll Excel using the arrow keys.

4. Restore the Excel File

Excel files can be damaged if you don’t close it correctly, or if Excel is open at the time. Repair Excel files if you are unable to scroll the worksheets after restarting Excel.

Note: It is a good idea to make a backup of your Excel file before you do any repairs.

1. Microsoft Excel can be opened File menu.

2. Select Browse You can find it in the “Other Locations” category.

3. Select the desired file, and then click the “Save As…” button down arrow icon Just click the button “Open”.

4. Select Open and Repair.

5. Select Repair to continue.

Excel should wait for validation checks for possible corruption to be performed. After the operation has been completed, you will see a dialogue box that displays the result of the file repair.

6. Select Close Now, check to make sure you are able to scroll through the Excel sheets.

5. Open Excel in Safe Mode

Microsoft Office software can be affected by corrupted or broken add-ins. Open Excel in Safe Mode You should immediately report a suspected bad case Recently installed add-in Scrolling is a result of this issue. You can save the document that you are working on and force quit Excel. Then, reopen Excel in Safe Mode.

Note: Microsoft Excel macOS lacks the Safe Mode feature.

Windows computers can be found her, Start the Task Manager, Microsoft Excel Choose and End task Click the menu at the top.

Keep the press button pressed Ctrl key Click on the Excel App icon. Excel boots by holding down the Ctrl key. You can select Yes Click on the prompt to ask if Excel should be opened in Safe Mode.

Excel is also possible in Safe Mode using the Windows Run Box.

Press Windows key + R, excel /safe Select the option you want to use in the dialogue box OK.

You can scroll the worksheets in Safe Mode if you disable any installed add-ins and then restart Excel. Check which add-in prevents you scrolling in Excel by re-enabling them one after the other.

Excel Add-Ins: How can you enable and disable them?

1. Open Excel and make a selection File Click the Ribbon tab.

2. Select More Use the sidebar for more information Options.

3. Open the Add-ins Tab, select Excel Add-ins Select the option “Manage” from the drop-down menu Go.

4. Select the add-in that you wish to disable, then deselect it OK. OK.

6. Deactivate “Zoom On Roll With IntelliMouse”

An Excel worksheet scrolls vertically by rotating the wheel of a mouse. You can use a Microsoft-branded mouse to scroll vertically IntelliMouse, , Excel zooms your worksheet instead.

To stop Excel zooming worksheets while moving the scroll wheel with an IntelliMouse, follow the below steps.

1. Open Excel’s File Choose from the following menus More Select the option from the sidebar Options.

2. Open the Advanced Tab, Uncheck Zoom on roll with IntelliMouse, OK.

7. Excel Application: Repair

Microsoft provides a repair tool which can diagnose and fix file corruption as well as other issues related to Office programs in Windows. Open Excel and save the files. Next, follow these steps to launch the Office repair tool.

1. Open the Control Panel Choose and Uninstall a program You can find it in the “Programs” category.

2. Select Microsoft Office or Microsoft 365 Choose and Change Click the menu at the top.

3. Select Yes On the “User Account Management” prompt.
4. Choose Quick Repair Select the Repair button.

5. Select the Repair Click the button once more to begin the repair operation.

Reopen Excel after the repair and check if your worksheets are now scrollable. Connect your computer to the internet and run an online repair (see step #4) if you still can’t scroll your Excel worksheets.

8. Microsoft Excel: Update

Office update installation is possible Microsoft Excel problems fixed These and many other Office applications.

1. Open Excel’s File Menu and selection Account You can find the sidebar.

2. Open the Update Options Select from drop-down menu Update Now.

3. Excel will automatically download the most recent version of Excel in the background. Choose Continue To install downloaded update.

4. When you receive a successful message, close the Excel update window.

You can update Excel on your MacBook from the App store or by using the Microsoft AutoUpdate Tool .

Scroll through your sheets

Contact us to get help with your computer’s reboot, updating its operating system and installing Excel Microsoft Office 365 Support If you have any questions, contact your local authorities.