How to fix Arrow keys in Excel

Arrow keys are commonly used in Excel to navigate through cells, select ranges, and move within worksheets. They provide a convenient way to move around and make selections without having to use the mouse. 

The arrow keys in Excel can be influenced by various factors such as frozen panes, hidden rows/columns, or specific settings. In this tutorial we will learn how to fix arrow keys in excel by following the simple methods below.

Method – 1 Disable Add-ins in Excel’s Status bar 

Step – 1 Go to File menu 

  • Run your Excel application, open the File menu.
  •  From the left sidebar click on Options and an Excel option dialogue box will appear.

Step – 2 Go to Excel Add-ins

  • Select the Add-ins, go to the drop-down menu.
  •  Select Excel Add-ins settings, and click Go an Add-ins dialogue box will appear 

Step – 3 Disable all Add-ins

  • Go to the Add-ins dialogue box.
  • Select all the Add-ins and uncheck them and click ok.

Method – 2 Disable Scroll Lock in Excel’s Status bar.

Step – 1 Go to status bar 

  • Launch Microsoft Excel, and then open a spreadsheet.
  • After the spreadsheet loads in, locate and right click on the Status bar.
  • Status bar is located at the bottom of your workbook. You can recognize it by looking for features such as the Zoom slider and Page Layout.

Step – 2 Disable Scroll lock 

  • Go to the pop up menu and locate the Scroll Lock option. Check the current status of this option. If it is ON state then turn it OFF by clicking on it.
  • Now arrow keys have been enabled in excel. 

Method – 3 Turn off the scroll lock.

Step – 1 Open On-Screen Keyboard.

  • Open the Start menu and select the search box at the bottom of the screen.
  • Search for  the on-screen keyboard and launch it.

Step – 2 Disable scroll lock.

  • Look at the right side of the keyboard. This shows you all the lock keys.
  • Select the ScrLk key. This disables the scroll lock and the problem will be resolved.

Method – 4 Enable Sticky Keys

Step – 1 Go to the Ease of Access Center.

  • Open your system’s Control Panel 
  • Click on Ease of Access Center.

Step – 2 Open Keyboard settings.    

  •  Click on Make the keyboard easier to use.
  •  In some operating systems, you may need to click Change how your keyboard works.

Step 3 Enable Sticky Keys.

  • Click on the option that says Turn on Sticky Keys.
  •  click on OK, Now Sticky keys have been enabled.