Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home » Excel

Excel Arrow Keys Not Moving Cells – How to Fix It?

Asmi DhakalBy Asmi DhakalJuly 26, 2022
Excel Arrow Keys Not Moving Cells

Microsoft Excel is popular choice to keep track of your records. While there are numerous spreadsheets in the market, excel certainly wins over for it’s usability and features. It is easy to update, calculate and navigate through your records.

Arrow key specially is quiet handy tool to shift through the rows and column. Granted, you still have mouse scrolls, but nothing can beat the arrow key. But recently, many users have reported that their arrow keys does not move cells or don’t work at all.

Although this issue isn’t as big as it looks, it sure is a hassle. Fortunately, we have listed all the ways you could fix if your arrow key is not working on excel.

How to Fix Excel Arrow Keys Not Moving Cells?

There can be a list of reasons why the arrow keys may not be moving cells. For starters, your scroll lock may be on, or applications you’ve shared shortcuts with may be actively using your arrow keys. Regardless of the issue, here is how you can solve this issue on Microsoft Excel.

Check for Hardware Issues

It may be possible that your arrow keys may not be working after all. Exit the Excel application, and test if the arrow keys work in other applications. If the arrow keys don’t work, likely your keyboard has malfunctioned. This may be because of several reasons, from debris stuck under the keys to an outdated keyboard driver. 

Learn more about how you can fix a malfunctioning keyboard. If these fixes do not apply to you, consider replacing your keyboard. 

Disable Scroll Lock

Most users accidentally enable their scroll lock through their keyboard. When you turn on the scroll lock, you’ll scroll through the sheet instead of moving through cells. Although this is an accessibility feature, we understand why it may confuse most new users. 

On Windows

You can turn off this feature by hitting the Scroll Lock key on your keyboard. Additionally, you can ever use the on-screen keyboard to disable this key. Hit the keyboard shortcut, Windows + Ctrl + O key, to open the onscreen keyboard for Windows. You may also open this utility from the settings app. 

ScrollLockWindows

Follow these steps to enable the on-screen keyboard from the settings app on your PC: 

  1. Hit the Windows + I key on your keyboard to open the Setting app.
  2.  From the navigation panel to your left, select Accessibility.
  3. Under Interaction, select Keyboard.
  4. Toggle on the slider for the On-screen keyboard. OnScreenKeyboardWindows

On Mac

Although Mac does not have a dedicated key as a scroll lock, you may also use the combination of Fn + Shift + F12 to enable or disable the scroll lock. Like Windows, you can also use the on-screen keyboard to perform this action. Use the shortcut Option + ⌘ (Command) + F5 to open on-screen keyboard for Mac.

ScrollLockMac

Use these steps to open the on-screen keyboard from System Preferences: 

  1. From your menu bar, launch Apple Menu.
  2. Go to System Preferences.
  3. Select Keyboard. 
  4. On the new window, select the Input Sources tab.
  5. Check the box next to the Show input menu in menu bar at the bottom of the window.
  6. A new icon must appear on your menu bar, select it. 
  7. Choose Show Keyboard Viewer.

Close Background Applications

You can share your keyboard shortcuts with certain applications on your PC. If these applications are actively running in the background, you will not be able to use certain keys. These applications may be actively using your arrow keys. Close all the applications running in your background and try using Excel again to see if the problem is solved.

On Windows

You can close these applications from the task manager. Follow these steps to close processes from the task manager:

  1. On your keyboard, hit the combination Ctrl + Shift + Esc.Taskmanagerwindows
  2. From the Processes tab, except for Windows Explorer, Task Manager, and Microsoft Excel, close all applications and check if the issue is fixed.
    discord-endtask
    If you don’t see the processes tab, select More details.

On Mac

If you’re a Mac user, you’ll need to force quit applications to close them. Use Option + Command + Esc to open the window for force quit on your keyboard. Select the applications and click on the Force Quit button.ForceQuitWindowMac

Disable COM Add-ins

Component Object Model (COM) Add-ins use the CommandBar button to perform certain actions. Although Add-ins are supposed to expand the functionality of your Sheets application, they might interfere with the regular functioning of the application. 

If you’ve encountered such problems while add-ins are enabled, you would want to disable them and try again. Follow these steps to disable COM Add-ins in Microsoft Excel.

  1. Open Microsoft Excel
  2. From the menu bar, select File.
  3. Scroll down to Options. If you cannot see Options, select More, then click on Options.
  4. From the sidebar, click on Add-ins.
  5. Drop down the menu next to Manage. 
  6. Select COM Add-ins, then click on the Go button.COMAddins1
  7. From the COM Add-ins window, make sure all boxes are disabled.COMAddins2
  8. To save changes, select OK.
  9. Close the windows and try to use the arrow keys to move through the cells.

Why is a Row Locked in Excel?

Another problem new Excel users might encounter is a frozen panel, row, or column. When you freeze a section,  sheets will keep them visible while you scroll through sheets. If only a particular pane isn’t moving while you scroll through your sheets, you’ve likely selected the Freeze Panes option for Excel.

This can be pretty annoying because as you scroll through your sheet, a particular section may block you from viewing other information. You may have either accidentally enabled this feature or forgotten about it. It is as easy to unfreeze them as it was to freeze them! Follow these steps to unfreeze the panes:

  1. Open the Microsoft Excel Application.
  2. Select View from the menu bar.
  3. Drop down the menu for Freeze Panes from the ribbon.
  4. Select Unfreeze [Panes/Top Row/ First Column].
    FreezePanes
  5. Scroll through your sheet and see if this solved the issue.

How Do I Enable Scrolling in Excel?

You can both vertically and horizontally scroll on Microsoft Excel. Although you could use the scroll bar to scroll through the sheet, you can also use the arrow keys. Use the arrow keys to scroll through the sheets, use the Scroll Lock key for Windows, and the combination of  Fn + Shift + F12 on Mac.

fix
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
how to turn off hardware acceleration

How to Turn Off Hardware Acceleration

September 22, 2023
motherboard chipset

Understanding Motherboard Chipset and Its Importance

September 20, 2023
Naval-Warfare-Games

Best Naval Warfare Games

September 18, 2023
You may also like
printer-not-printing

How to Fix a Printer That’s Not Printing

September 20, 2023
Share Location With Friends and Family

Share Location With Friends and Family (iPhone and Android)

September 18, 2023
how-to-print-without-a-printer

How to Print Without a Printer

September 18, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday, editor@technewstoday.com | Tech Central Pvt. Ltd.

Type above and press Enter to search. Press Esc to cancel.