在处理 Excel 电子表格(working on an Excel spreadsheet)时,在单元格之间移动的最佳方法是使用键盘上的箭头键。有了这些可用于每个方向的键,您只需按一下键即可轻松地从一个单元格转到另一个单元格。
有时,这些箭头键在Excel(Excel)中不起作用。在某些情况下,他们甚至会将您带到下一个工作表,而不是移动到该行中的下一个单元格。如果您对这种行为感到沮丧,您可能想知道如何解决它。
修复箭头键在Excel(Excel)中不起作用的问题实际上比您想象的要容易。在大多数情况下,您只需敲击一次按键就可以让按键完成他们应该做的事情。
此外,请务必观看我们的YouTube 视频(YouTube video ),我们将在一个简短而紧凑的视频中介绍本文中提到的不同解决方案。
禁用滚动锁定(Disable Scroll Lock)
箭头键在Excel(Excel)中不起作用的常见原因之一是您在计算机上启用了滚动锁定功能。只要它保持启用状态,这些键就不会做他们应该做的事情。
如果您看一下您的键盘,您会发现滚动锁定按钮的指示灯已打开。它表示锁定已启用,您需要将其关闭以激活箭头键。
如果上述原因是箭头键在您计算机上的Excel中不起作用的原因,则只需按一下键即可修复它。
- 只需按下键盘上的滚动锁定(scroll lock)按钮,锁定将被禁用。
使用屏幕键盘关闭滚动锁定(Use The On-Screen Keyboard To Turn Off Scroll Lock)
如果您使用的是现代计算机和同样现代的键盘,您可能会注意到键盘上没有滚动锁定按钮。这是因为大多数现代设备已经取消了该按钮,认为大多数用户不会使用它。
但是,Windows有一个屏幕键盘可帮助您使用实际键盘上不存在的键。您也可以在真正的键盘损坏(when your real keyboard gets broken)或无法正常工作的情况下使用它。
您可以使用此屏幕键盘关闭滚动锁定。
- 打开开始菜单(Start Menu)并搜索并启动屏幕键盘(On-Screen Keyboard)。它应该打开。
- 在键盘的右侧,您会找到所有锁定键。将有一个名为ScrLk的键,它可以帮助您启用和禁用 PC 上的滚动锁定。单击(Click)它,如果之前启用了滚动锁定,它将禁用滚动锁定。
修复箭头键不适用于 Mac 上的 AppleScript(Fix Arrow Keys Not Working With An AppleScript On Mac)
Mac键盘上通常没有滚动锁定按钮,因此如果您是Mac用户,禁用该功能对您来说是一项艰巨的任务。但是,有一种解决方法可以使用AppleScript让您在Mac上的Excel中解决问题。
当您在计算机上使用Excel(Excel)时,解决方法会创建一个AppleScript并运行它。然后它会做它需要做的事情来让箭头键在Excel程序中工作。
创建AppleScript并执行它可能听起来有点技术性,但实际上很容易做到。
- 单击Launchpad,搜索TextEdit,然后打开它。
- 单击顶部的“文件”菜单并选择(File)“新建”(New)以创建新文档。
set returnedItems to (display dialog "Press OK to send scroll lock keypress to Microsoft Excel or press Quit" with title "Excel Scroll-lock Fix" buttons {"Quit", "OK"} default button 2)
set buttonPressed to the button returned of returnedItems
if buttonPressed is "OK" then
tell application "Microsoft Excel"
activate
end tell
tell application "System Events"
key code 107 using {shift down}
end tell
activate
display dialog "Scroll Lock key sent to Microsoft Excel" with title "Mac Excel Scroll-lock Fix" buttons {"OK"}
end if
- 按Command + S键保存文件。
- 输入FixExcelKeys.applescript作为文件名并保存。
- 在Excel(Excel)中启动您的电子表格。
- 双击(Double-click)新创建的AppleScript文件,它应该会为您解决问题。
启用粘滞键(Enable Sticky Keys)
在大多数情况下,上述方法应该可以为您解决Excel(Excel)中箭头键不起作用的问题。但是,如果您对它们没有任何运气,您可能需要多尝试一些,看看它们是否能帮助您解决问题。
其中一种方法是在 Windows计算机上启用粘滞键功能。(enable the sticky keys feature on your Windows)虽然它与Excel或箭头键没有直接关系,但值得切换它以查看它是否为您解决了问题。
- 使用Cortana搜索搜索控制面板(Control Panel)并启动它。
- 单击轻松访问中心(Ease of Access Center)。
- 单击使键盘更易于使用(Make the keyboard easier to use)。
- 启用“打开粘滞键(Turn on Sticky Keys)”选项,然后单击“确定(OK)” 。
禁用加载项(Disable Add-Ins)
加载项可帮助您充分利用Excel,但有时它们也会导致冲突。如果您安装了任何加载项,您可能需要禁用它们并查看箭头键是否开始工作。
在Excel软件中禁用加载项相当容易。
- 在您的计算机上启动Excel 。
- 单击顶部的文件(File)菜单,然后从左侧边栏中选择选项。(Options)
- 单击左侧栏中的加载项(Add-ins)以查看您的Excel加载项设置。
- 从下拉菜单中选择Excel Add-ins,然后单击Go。
- 取消选择(Deselect)所有加载项,然后单击OK。
- 对下拉菜单中的每个选项执行上述步骤,以便禁用所有加载项。
我们希望您的箭头键在Excel(Excel)中不起作用的问题现在已经解决。如果是这样,我们想知道哪种方法对您有效。请在下面的评论中告诉我们。
How To Fix Arrow Keys Not Working In Excel
Whеn you’re working on an Excel spreadsheet, the best way to move between cells is to use the arrow keys on your keyboard. With these keys available for each direction, you can easily go from one cell to another with a single key-press.
Sometimes, it happens that these arrow keys do not work in Excel. In some cases, they even take you to the next worksheet instead of moving to the next cell in the line. If you’re frustrated by this behavior, you’ll probably want to find out how to fix it.
Fixing the arrow keys not working in Excel issue is actually easier than you think. In most cases, you’re just a single keystroke away from getting the keys to do what they should be doing.
Also, be sure to watch our YouTube video where we go through the different solutions mentioned in this article in a short and compact video.
Disable Scroll Lock
One of the common reasons why the arrow keys don’t work in Excel is because you’ve enabled the scroll lock feature on your computer. For as long as it remains enabled, the keys won’t do what they’re supposed to do.
If you take a look at your keyboard, you’ll find that the light for the scroll lock button is turned on. It indicates the lock is enabled, and you need to turn it off to activate the arrow keys.
If the above reason is why the arrow keys are not working in Excel on your computer, fixing it is just a matter of a key press.
- Simply press the scroll lock button on your keyboard and the lock will be disabled.
- You should find that the scroll lock light is no longer on on your keyboard.
Use The On-Screen Keyboard To Turn Off Scroll Lock
If you’re using a modern computer with an equally modern keyboard, you may notice that there’s no scroll lock button on your keyboard. It’s because most modern equipment has done away with that button thinking most users just won’t use it.
However, Windows has an on-screen keyboard available to help you use the keys that don’t exist on your actual keyboard. You can also use it on the occasions when your real keyboard gets broken or just won’t function normally.
You can use this on-screen keyboard to turn the scroll lock off.
- Open the Start Menu and search for and launch On-Screen Keyboard. It should open.
- On the right-hand side of the keyboard, you’ll find all the lock keys. There’ll be a key named ScrLk which should help you enable and disable scroll lock on your PC. Click on it and it’ll disable the scroll lock if it was enabled before.
Fix Arrow Keys Not Working With An AppleScript On Mac
Mac keyboards usually don’t have the scroll lock button on them and so disabling the feature is quite a task for you if you’re a Mac user. However, there’s a workaround that uses an AppleScript to let you fix the issue in Excel on your Mac.
The workaround creates an AppleScript and runs it when you use Excel on your machine. It then does what it needs to do to get the arrow keys to work in the Excel program.
Creating an AppleScript and executing it may sound a bit technical but it’s actually pretty easy to do.
- Click on Launchpad, search for TextEdit, and open it.
- Click on the File menu at the top and select New to create a new document.
- Copy the following code and paste it into your document.
set returnedItems to (display dialog "Press OK to send scroll lock keypress to Microsoft Excel or press Quit" with title "Excel Scroll-lock Fix" buttons {"Quit", "OK"} default button 2)
set buttonPressed to the button returned of returnedItems
if buttonPressed is "OK" then
tell application "Microsoft Excel"
activate
end tell
tell application "System Events"
key code 107 using {shift down}
end tell
activate
display dialog "Scroll Lock key sent to Microsoft Excel" with title "Mac Excel Scroll-lock Fix" buttons {"OK"}
end if
- Press the Command + S keys to save the file.
- Enter FixExcelKeys.applescript as the name of the file and save it.
- Launch your spreadsheet in Excel.
- Double-click on the newly created AppleScript file and it should fix the issue for you.
Enable Sticky Keys
In most cases, the above methods should fix the arrow keys not working in Excel issue for you. However, if you didn’t have any luck with them, you might want to try a few more and see if they help you resolve the problem.
One of these methods is to enable the sticky keys feature on your Windows computer. While it isn’t directly related to Excel or arrow keys, it’s worth toggling it to see if it fixes the issue for you.
- Search for Control Panel using Cortana search and launch it.
- Click on Ease of Access Center.
- Click on Make the keyboard easier to use.
- Enable the option that says Turn on Sticky Keys and click on OK.
Disable Add-Ins
Add-ins help you get more out of Excel but sometimes they can cause conflicts as well. If you have any add-ins installed, you may want to disable them and see if the arrow keys then start working.
It’s fairly easy to disable add-ins in the Excel software.
- Launch Excel on your computer.
- Click on the File menu at the top and select Options from the left sidebar.
- Click on Add-ins in the left sidebar to view your Excel add-ins settings.
- Select Excel Add-ins from the dropdown menu and click on Go.
- Deselect all the add-ins and click on OK.
- Do the above steps for every option in the dropdown menu so that all of your add-ins are disabled.
We hope your arrow keys not working in Excel issue is now resolved. And if so, we’d like to know what method worked for you. Let us know in the comments below.