Step 3: On the page that appears, click on “add-ins.” Select “Excel Add-ins” and hit the “Go option.” Step 2: Click on the “File” menu and go “Option” as shown below
The following is a systematic procedure on how to disable Excel add-ons if arrow keys aren't working properly. However, they can also lead to arrow keys not working as expected. Close the Control Panel.Įxcel add-ons come with numerous benefits. Step 4: On the page that appears, mark the option that says, “Turn on Sticky Keys,” and click apply. Step 3: Scroll down and click the “ Make the keyboard easier to use” option as shown below. Step 2: Click on “Control Panel app,” scroll to “Ease of Access Center,” and click it. Step 1: Click the “start button” and search for “Control Panel.” Press “Shift Key” 5 times in a row Method 2 The following are simple methods on how to enable the sticky keys on your computer. It may sound weird, but enabling the stick keys on your Windows computer can resolve the problem of arrow keys not working on excel. Step 3: Go to the “Scroll lock” option and unmark it as shown below
Step 2: Locate the “Status bar” (on the right bottom of your workbook) and right-click it Step 1: Launch Microsoft Excel and open a spreadsheet page You can also unlock scroll lock from Excel’s “Status bar” feature Step 3: Look for the ScrLk key in the “on-screen keyboard” and use it to disable the scroll lock. Step 2: Search On-Screen Keyboard and click on it to open Step 1: Click in the “start menu” button (at the left bottom of the screen) You can use the on-screen windows keyboard to turn off the scroll lock. Those using Mac, press F14 or Shift + F14 key combination to disable scroll lock Use virtual keyboard
If your keyboard doesn’t have the “Scroll lock” button, press fn+C On Mac The following are methods that can use to turn off the scroll lock 104 keyboardįor those using windows computers, just locate the “Scroll lock” button on the keyboard and press it. Therefore, you should turn off the scroll lock when using arrow keys to input data in excel cells.
The role of the scroll lock key is to prevent accidental touch when using the keyboard of your PC or laptop. You’re likely to experience problems using arrow keys to move from one cell to another on excel if the scroll lock is on. That way, you can easily use arrow keys to navigate from one cell to another without experiencing challenges. You can avoid arrow key failure by pressing “enter” every time you finish entering some data in cells. Normally, Excel assumes that you haven’t finished typing if you don’t press “enter” after entering data or formula on cells.Ĭonsequently, pressing the arrow key moves the table instead of moving to the next cell. One of the reasons why arrow keys fail to work as expected in excel is if you don’t press “Enter” after entering data in a cell. The following are simple tips that you can use to solve the problem and continue using arrow keys to navigate cells on excel. Unfortunately, sometimes arrow keys fail to work, and you are stuck. You can easily use them to enter data in excel and navigate target cells without using the mouse. Have you ever tried to input some data in Excel? Then you know that arrow keys on the keyboard are of great help. Arrow keys allow you to accurately jump to target cells in Excel, but sometimes they don't work.