Excel Arrow Keys Not Moving Cells

Microsoft Excel is common option to keep monitor of your data. While there are quite a few spreadsheets available in the market, excel actually wins over for it’s usability and options. It is simple to update, calculate and navigate by way of your data.

Arrow key specifically is quiet helpful instrument to shift by way of the rows and column. Granted, you continue to have mouse scrolls, however nothing can beat the arrow key. But not too long ago, many customers have reported that their arrow keys doesn’t transfer cells or don’t work in any respect.

Although this problem isn’t as huge because it seems to be, it certain is a problem. Fortunately, we now have listed all of the methods you could possibly repair in case your arrow key shouldn’t be engaged on excel.

How to Fix Excel Arrow Keys Not Moving Cells?

There generally is a record of the reason why the arrow keys will not be shifting cells. For starters, your scroll lock could also be on, or purposes you’ve shared shortcuts with could also be actively using your arrow keys. Regardless of the difficulty, right here is how one can remedy this problem on Microsoft Excel.

Check for Hardware Issues

It could also be potential that your arrow keys will not be working in any case. Exit the Excel utility, and take a look at if the arrow keys work in different purposes. If the arrow keys don’t work, seemingly your keyboard has malfunctioned. This could also be due to a number of causes, from particles caught below the keys to an outdated keyboard driver. 

Learn more about how one can repair a malfunctioning keyboard. If these fixes don’t apply to you, take into account changing your keyboard. 

Disable Scroll Lock

Most customers by chance allow their scroll lock by way of their keyboard. When you activate the scroll lock, you’ll scroll by way of the sheet as an alternative of shifting by way of cells. Although that is an accessibility function, we perceive why it might confuse most new customers. 

On Windows

You can flip off this function by hitting the Scroll Lock key in your keyboard. Additionally, you possibly 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 might also open this utility from the settings app. 

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

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

On Mac

Although Mac doesn’t have a devoted key as a scroll lock, you might also use the mix of Fn + Shift + F12 to allow or disable the scroll lock. Like Windows, you too can use the on-screen keyboard to carry out this motion. Use the shortcut Option + ⌘ (Command) + F5 to open on-screen keyboard for Mac.

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 brand new window, choose the Input Sources tab.
5. Check the field next to the Show enter menu in menu bar on the backside of the window.
6. A brand new icon should seem in your menu bar, choose it. 
7. Choose Show Keyboard Viewer.

Close Background Applications

You can share your keyboard shortcuts with sure purposes in your PC. If these purposes are actively operating within the background, you will be unable to make use of sure keys. These purposes could also be actively using your arrow keys. Close all of the purposes operating in your background and take a look at using Excel once more to see if the issue is solved.

On Windows

You can shut these purposes from the duty supervisor. Follow these steps to shut processes from the duty supervisor:

1. On your keyboard, hit the mix Ctrl + Shift + Esc.
2. From the Processes tab, aside from Windows Explorer, Task Manager, and Microsoft Excel, shut all purposes and test if the difficulty is fastened. If you don’t see the processes tab, choose More particulars.

On Mac

If you’re a Mac consumer, you’ll must drive give up purposes to shut them. Use Option + Command + Esc to open the window for drive give up in your keyboard. Select the purposes and click on on the Force Quit button.

Disable COM Add-ins

Component Object Model (COM) Add-ins use the CommandBar button to carry out sure actions. Although Add-ins are purported to develop the performance of your Sheets utility, they may intrude with the common functioning of the appliance. 

If you’ve encountered such issues whereas add-ins are enabled, you’d need to disable them and take a look at once more. Follow these steps to disable COM Add-ins in Microsoft Excel.

1. Open Microsoft Excel
2. From the menu bar, choose File.
3. Scroll all the way down to Options. If you can not see Options, choose More, then click on on Options.
4. From the sidebar, click on on Add-ins.
5. Drop down the menu next to Manage. 
6. Select COM Add-ins, then click on on the Go button.
7. From the COM Add-ins window, be certain that all packing containers are disabled.
8. To save modifications, choose OK.
9. Close the windows and attempt to use the arrow keys to maneuver by way of the cells.

Why is a Row Locked in Excel?

Another downside new Excel customers may encounter is a frozen panel, row, or column. When you freeze a piece,  sheets will keep them seen whilst you scroll by way of sheets. If solely a selected pane isn’t shifting whilst you scroll by way of your sheets, you’ve seemingly chosen the Freeze Panes possibility for Excel.

This will be fairly annoying as a result of as you scroll by way of your sheet, a selected part might block you from viewing different data. You might have both by chance enabled this function or forgotten about it. It is as straightforward to unfreeze them because 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].
5. Scroll by way of your sheet and see if this solved the difficulty.

How Do I Enable Scrolling in Excel?

You can each vertically and horizontally scroll on Microsoft Excel. Although you could possibly use the scroll bar to scroll by way of the sheet, you too can use the arrow keys. Use the arrow keys to scroll by way of the sheets, use the Scroll Lock key for Windows, and the mix of  Fn + Shift + F12 on Mac.