Arrows Not Moving Cells In Excel [SOLVED]



Excel arrow moves page instead of cell

If you have happen to be moving the page viewed instead of the cell selected in Microsoft Excel‌ with using the keyboard arrow keys, do not panic.

Like most issues in MS Excel, solving the Arrows Not moving cells In Excel is one of the simple MS Excel‌ shortcuts and formulas that you can learn in a few steps and apply in different situations. Let’s see how to solve it – and why it even happens at all.

Microsoft Excel online training

Open the On-Screen Keyboard, and uncheck the ScrLk (Screen Lock) key, and you're done !

Issue explanation

Usually, when you are in cell A1, and you press the keyboard arrow key right

You expect to end up with cell B1 selected :

If, instead, the screen display moved one cell right - still with cell A1 selected :

All you have to do is open Windows menu, enter keyboard in the search bar, and open the On-Screen Keyboard :

Here, with the Excel window open in foreground, the ScrLk key should be white, meaning selected :

Simply click on the ScrLk key to deselect it :

Go back to Excel, and pressing the right arrow key while having A1 cell selected should move the selection to cell B1

Excel not scrolling cells with arrow keys

This issue of excel arrows not moving cells happens when the screenlock option has been checked.


It leads to excel arrow keys move page not cell, pressing this key in excel change arrow key behavior.

If the arrow keys move screen not cell in excel, then simply open the virtual keyboard and change the screenlock key, and excel arrow keys not moving cells will be solved !

Excel scrolling instead of moving cells

When Excel is scrolling instead of moving cells, due to inadvertently activating the scroll lock option, there is only one way to deactivate it.

Activate the on screen keyboard and switch off the scroll lock option, by finding the desktop app in Windows search menu in the bottom left of the screen.

Then, simply deactivate the scroll lock option directly from the virtual keyboard.

What is the SCRLK key on keyboard for?

The SCRLK key on keyboard was originally added to computer keyboards in order to have a way to make the computer window scrolling using keyboard only, however it hasn’t as useful as it used to be, as it is possible to scroll with a mouse, or even with a finger on touchscreens. But that hasn’t always been the case

SCRLK key on keyboard: scroll in a window using keyboard arrows

Nowadays, if you press by mistake that key, or activate the function within a software, you will end up experience arrows not moving cells in Excel as the arrow keys will instead make you lock the scrolling function.

Arrows Not Moving Cells In Excel: solve it by deactivating the SCRLK key on keyboard

If you have activated that function by mistake, and end up having the arrows not moving cells in Excel then simply open the on screen keyboard, by looking for the keyboard in the Windows menu, and deactivate the option. If it is activated, the SCRLK key on keyboard should be highlighted and easily identifiable.

Turn off Scroll Lock - Excel - Microsoft Support

Complete 2019 Excel for Beginners in video

International Business Consulting
About the author - International Business Consulting
Yoann is an International Business Consultant, facilitator and coordinator. He worked more than 10 years in global business, supply chain, financial, SAP ERP projects, Web and SEO optimization for various industries, such as logistics, cosmetics, consumer goods, beauty care, or fashion, in more than 30 countries around the globe.
 




Comments (12)

Nora Lowe, 2018-08-19
Great, that's exactly what I was looking for, now I'm ready
Elbert Morales, 2018-08-19
Thanks.
Jimmy Mcdaniel, 2018-08-19
Simple, clear and explained, thanks very much
Joyce Adams, 2018-08-19
Great piece of information, thanks for sharing
Chermaki, 2018-08-19
Can't believe I finally found the solution, this was a nightmare for a long time, now resolved
NumSmarter, 2018-08-19
Exactly what i was looking for, perfect
ffffalseU, 2018-08-19
Thanks to great information, sharing
truchavasU, 2018-08-19
Yes, that's what I need
tatikka, 2018-12-19
All you have to do is open Windows menu, enter keyboard in the search bar, and open the On-Screen Keyboard. I can not find anything named On-Screen keyboard.
Enzo, 2019-01-17
Thank you very much for helping. These tips seem useless but, for those who do not know many commands, they are indispensable! Good job!!
Liviu, 2020-09-24
Thank you ! I solved the problem :) !
admin, 2020-09-24
Amazing! Glad it helped )

Leave a comment