您是否(Are)在使用鼠标、触摸板或键盘箭头键滚动Excel 电子表格时遇到问题？(Excel spreadsheets)该问题是否影响工作簿中的所有或特定工作表？您的工作表中是否缺少滚动条？
本教程涵盖了针对Windows和Mac计算机
上Excel中与滚动相关的故障的多个故障排除修复程序。
1.解冻窗格
如果您滚动时电子表格的第一行或第一列是静止的，则它可能会被冻结。按照以下步骤释放工作表中的冻结窗格。
在 Windows 中解冻 Excel 窗格
- 打开 Excel 的视图选项卡。
- 打开“冻结窗格”下拉菜单并选择“解冻窗格(Unfreeze Panes)” 。
(Scroll)使用鼠标滚轮或触摸板向下滚动电子表格，检查“解冻窗格”功能是否解决了问题
。
在 macOS 中解冻 Excel 窗格
打开 Excel 的视图(View)选项卡，选择窗口(Window)下拉菜单，然后选择解冻窗格(Unfreeze Panes)。
2.重新启用滚动条
Excel中的电子表格通常具有水平和垂直滚动条，以便于导航。如果电子表格中缺少滚动条，请按照以下步骤启用它们。如果滚动条被冻结或不起作用，重新启用它们可能会解决问题。
- 打开 Excel 的文件选项卡。
- 在边栏上选择(Select)更多，然后选择选项。
- 在边栏上选择“高级(Select Advanced)”，然后滚动到“此工作簿的显示选项”部分。选中显示(Show)水平滚动条和显示(Show)垂直滚动条
旁边的复选框。
- 选择确定(Select OK)以保存更改并退出“Excel 选项”窗口。
3.禁用滚动锁定
打开Scroll Lock会禁用计算机的箭头键。如果您无法使用箭头键滚动 Excel 工作表(can’t scroll Excel sheets using the arrow keys)，请禁用Scroll Lock 并重(Scroll Lock)试。
禁用 Excel 的内置滚动锁定(Built-In Scroll Lock)
- 右键单击(Right-click)工作表底部的状态栏。
- 如果Scroll Lock(Scroll Lock)旁边有复选标记，请选择它以禁用该功能。
禁用键盘(Your Keyboard)上的滚动锁定(Scroll Lock)
在键盘上寻找“ Scroll Lock ”（或“ScrLk”）键或指示灯。如果该键或指示灯亮起，请按Scroll Lock键关闭该功能并启用箭头键。
通过屏幕键盘(On-Screen Keyboard)禁用滚动锁定(Scroll Lock)
您还可以通过计算机的屏幕键盘
禁用Scroll Lock 。
使用Windows键+ Ctrl + O键盘快捷键打开 Windows 屏幕键盘(turn on Windows On-Screen keyboard)。
或者，转到Settings > Accessibility > Keyboard并打开屏幕键盘。
在Windows 10中，转到Settings > Ease使用” Access > Keyboard” ，然后打开“使用(Use)屏幕键盘”(On-Screen Keyboard)。
(Scroll Lock)如果“ ScrLk ”键具有蓝色背景，则滚动锁定处于活动状态。取消选择ScrLk键以关闭Scroll Lock。您现在应该能够使用箭头键
滚动Excel电子表格。(Excel)
4.修复Excel文件
在使用Excel(Excel)时未正确关闭Excel或关闭计算机可能会损坏您的工作簿。如果在重新启动Excel(Excel)或计算机后无法滚动工作表，请修复Excel文件并重试。
注意：我们建议在执行修复之前
创建Excel文件的备份副本。
- 打开Microsoft Excel 文件(Microsoft Excel File)菜单。
- (Select Browse)在“其他位置”类别中
选择浏览。
- 选择文件并选择“打开”按钮旁边的向下箭头图标。
- 选择打开并修复。
- 选择修复以继续。
等待(Wait)Excel对潜在损坏执行验证检查。操作完成后，应弹出一个显示文件修复结果的对话框。
- 选择关闭(Select Close)并检查您现在是否可以滚动Excel工作簿中的工作表。
5.以安全模式打开Excel
损坏(Corrupt)或错误的加载项可能会导致Microsoft Office应用程序出现故障。如果您怀疑滚动问题是由错误的或最近安装的加载项引起的，请(recently installed add-in)以安全模式打开 Excel 。(Open Excel in safe mode)保存您正在处理的文档，强制退出Excel，然后在安全模式下(Safe Mode)重新打开应用程序。
注意：适用于 macOS 的Microsoft Excel没有安全模式(Safe Mode)功能。
在 Windows 计算机上，打开任务管理器(open the Task Manager)，选择Microsoft Excel，然后选择顶部菜单上的
结束任务。(End)
按住Ctrl键并选择Excel应用程序图标。在Excel(Excel)启动时按住Ctrl键。在询问是否要以安全模式打开(Safe Mode)Excel的弹出窗口中选择是(Select Yes)。
您还可以通过Windows 运行(Windows Run)框
以安全模式打开(Safe Mode)Excel 。
按Windows键 + R，在对话框中键入或粘贴 excel /safe，然后选择确定。
如果您可以在安全模式下(Safe Mode)滚动工作表，请禁用所有已安装的加载项，然后重新启动Excel。一个接一个地重新启用加载项，并检查哪个阻止您在Excel中滚动工作表。
如何启用和禁用 Excel 加载项(Disable Excel Add-Ins)
- 打开Excel并在功能区(Ribbon)选项卡
上选择文件。(File)
- 选择(Select)边栏上的更多，然后选择选项。
- 打开加载项(Add-ins)选项卡，在“管理”下拉菜单中
选择Excel 加载项，然后选择转到。(Excel Add-ins)
- 取消选择要禁用的加载项，然后选择“确定”。要启用或激活加载项，请选中加载项旁边的框，然后选择确定。
6. 禁用“(Roll)使用IntelliMouse缩放(Zoom)滚动”
移动物理鼠标上的滚轮可垂直滚动Excel工作表。(Excel)使用 Microsoft 品牌的鼠标或IntelliMouse，Excel会改为缩放您的工作表。
按照以下步骤在IntelliMouse(IntelliMouse)上移动滚轮时阻止Excel缩放工作表。
- 打开 Excel 的文件(File)菜单，选择边栏上的更多，然后选择选项。
- 打开Advanced选项卡，取消选中Zoom on roll with IntelliMouse，然后选择 OK。
7.修复Excel应用程序
Microsoft有一个修复工具，可以诊断和修复(Microsoft)Windows中(Windows)Office应用程序的文件损坏和其他问题。保存文件，关闭Excel，然后按照以下步骤运行Office修复工具。
- 打开控制面板(Control Panel)并在“程序”类别中
选择卸载程序。(Uninstall)
- 选择 Microsoft Office(Select Microsoft Office)或Microsoft 365 ，然后在顶部菜单中
选择更改。(Change)
- 在“用户帐户控制”提示中
选择是。(Yes)
- 选择快速修复(Choose Quick Repair)并选择修复(Repair)按钮。
- 再次选择修复(Repair)按钮开始修复操作。
修复后重新打开 Excel(Reopen Excel)并检查您的工作表现在是否可滚动。如果您仍然无法滚动Excel工作表，请将您的计算机连接到互联网并运行在线修复（请参阅步骤 #4）。
8. 更新 Microsoft Excel
安装 Office 更新可以解决 Microsoft Excel(fix issues with Microsoft Excel)和其他 Office 应用程序的问题。
- 打开 Excel 的文件(File)菜单并选择侧边栏上的帐户(Account)。
- 打开更新(Update) 选项(Options)下拉菜单并选择立即更新(Update)。
- Excel将在后台下载最新版本的应用程序。选择继续(Select Continue)安装下载的更新。
- 收到成功消息
后，关闭更新窗口并重新打开Excel 。
如果您使用MacBook ，请从App Store更新Excel或使用Microsoft AutoUpdate 工具(Microsoft AutoUpdate tool)。
滚动浏览你的工作表
(Reboot)如果问题仍然存在
，请重新启动计算机、更新其操作系统、重新安装Excel或联系Microsoft Office 365 支持。(Microsoft Office 365 Support)
Can’t Scroll in Microsoft Excel? 8 Ways to Fix
Are you having problems scrollіng through Excel spreadsheets with your mouse, touchpad, or keyboard arrow keys? Does the issue affect all or specific sheets in your workbook? Is the scroll bar missing in your worksheets?
This tutorial covers several troubleshooting fixes for scrolling-related malfunctions in Excel on Windows and Mac computers.
1. Unfreeze Panes
The first row or column of your spreadsheet is likely frozen if it’s stationary when you scroll. Follow the steps below to release frozen panes in your worksheet.
Unfreeze Excel Panes in Windows
- Open Excel’s View tab.
- Open the “Freeze Panes” drop-down menu and select Unfreeze Panes.
Scroll down the spreadsheet with your mouse wheel or touchpad and check if the “Unfreeze Panes” feature fixed the issue.
Unfreeze Excel Panes in macOS
Open Excel’s View tab, select the Window drop-down menu, and choose Unfreeze Panes.
2. Re-Enable the Scroll Bar
Spreadsheets in Excel typically have a horizontal and vertical scroll bar for easy navigation. If the scroll bars are missing in your spreadsheet, follow the steps below to enable them. If the scroll bars are frozen or don’t work, re-enabling them might fix the issue.
- Open Excel’s File tab.
- Select More on the sidebar and select Options.
- Select Advanced on the sidebar and scroll to the “Display options for this workbook” section. Select the checkboxes next to Show horizontal scroll bar and Show vertical scroll bar.
- Select OK to save the changes and exit the “Excel Options” window.
3. Disable Scroll Lock
Turning on Scroll Lock disables your computer’s arrow keys. If you can’t scroll Excel sheets using the arrow keys, disable Scroll Lock and try again.
Disable Excel’s Built-In Scroll Lock
- Right-click the status bar at the bottom of your worksheet.
- If there’s a checkmark next to Scroll Lock, select it to disable the feature.
Disable Scroll Lock on Your Keyboard
Look for a “Scroll Lock” ( or “ScrLk”) key or indicator light on your keyboard. If the key or indicator is lit, press the Scroll Lock key to turn off the feature and enable your arrow keys.
Disable Scroll Lock via On-Screen Keyboard
You can also disable Scroll Lock through your computer’s on-screen keyboard.
Use the Windows key + Ctrl + O keyboard shortcut to turn on Windows On-Screen keyboard.
Alternatively, go to Settings > Accessibility > Keyboard and toggle on the On-screen keyboard.
In Windows 10, go to Settings > Ease of Access > Keyboard and toggle on Use the On-Screen Keyboard.
Scroll Lock is active if the “ScrLk” key has a blue background. Deselect the ScrLk key to turn off Scroll Lock. You should now be able to scroll your Excel spreadsheet using the arrow keys.
4. Repair the Excel File
Not closing Excel correctly or shutting down your computer while Excel’s in use can corrupt your workbook. If you can’t scroll a worksheet after restarting Excel or your computer, repair the Excel file and try again.
Note: We recommend creating a backup copy of the Excel file before performing a repair.
- Open the Microsoft Excel File menu.
- Select Browse in the “Other locations” category.
- Choose the file and select the down arrow icon next to the “Open” button.
- Select Open and Repair.
- Select Repair to continue.
Wait for Excel to perform validation checks for potential corruption. A dialog box displaying the file repair result should pop up when the operation’s complete.
- Select Close and check if you can now scroll the sheets in the Excel workbook.
5. Open Excel in Safe Mode
Corrupt or buggy add-ins can cause Microsoft Office applications to malfunction. Open Excel in safe mode if you suspect a bad or recently installed add-in is responsible for the scrolling issue. Save the document you’re working on, force quit Excel, and reopen the app in Safe Mode.
Note: Microsoft Excel for macOS doesn’t have the Safe Mode feature.
On Windows computers, open the Task Manager, select Microsoft Excel and select End task on the top menu.
Press and hold the Ctrl key and select the Excel app icon. Keep holding the Ctrl key while Excel boots. Select Yes on the pop-up asking if you want to open Excel in Safe Mode.
You can also open Excel in Safe Mode through the Windows Run box.
Press Windows key + R, type or paste excel /safe in the dialog box, and select OK.
If you can scroll worksheet(s) in Safe Mode, disable all installed add-ins, and restart Excel. Re-enable the add-ins one after another and check which one prevents you from scrolling worksheets in Excel.
How to Enable and Disable Excel Add-Ins
- Open Excel and select File on the Ribbon tab.
- Select More on the sidebar and choose Options.
- Open the Add-ins tab, choose Excel Add-ins in the “Manage” drop-down menu, and select Go.
- Deselect the add-in you want to disable and select OK. To enable or activate an add-in, check the box next to the add-in, and select OK.
6. Disable “Zoom on Roll with IntelliMouse”
Moving the wheel on a physical mouse scrolls an Excel worksheet vertically. With a Microsoft-branded mouse or IntelliMouse, Excel zooms your worksheet instead.
Follow the steps below to stop Excel from zooming worksheets when moving the scroll wheel on an IntelliMouse.
- Open Excel’s File menu, select More on the sidebar, and choose Options.
- Open the Advanced tab, uncheck Zoom on roll with IntelliMouse, and select OK.
7. Repair the Excel Application
Microsoft has a repair tool that diagnoses and fixes file corruption and other issues with Office applications in Windows. Save your files, close Excel, and follow the steps below to run the Office repair tool.
- Open the Control Panel and select Uninstall a program in the “Programs” category.
- Select Microsoft Office or Microsoft 365 and select Change on the top menu.
- Select Yes on the “User Account Control” prompt.
- Choose Quick Repair and select the Repair button.
- Select the Repair button again to start 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. Update Microsoft Excel
Installing Office updates can fix issues with Microsoft Excel and other Office applications.
- Open Excel’s File menu and select Account on the sidebar.
- Open the Update Options drop-down menu and select Update Now.
- Excel will download the latest version of the app in the background. Select Continue to install the downloaded updates.
- Close the update window and reopen Excel when you get a success message.
If you use a MacBook, update Excel from the App Store or use the Microsoft AutoUpdate tool.
Scroll Through Your Sheets
Reboot your computer, update its operating system, reinstall Excel, or contact Microsoft Office 365 Support if the issue persists.
