When working with Excel, you may need to move cells in excel. It sometimes becomes challenging to complete an easy task. Therefore, you should determine the problem and the reason for it. Furthermore, you should resolve the problem effectively. In this article, we’ll discuss five ways to fix the problem of “unable to move cells in Excel”. Let’s follow the complete guide to learn all of this.
How to Fix When Excel Cells Are Unable to Move: 5 Solutions
Sometimes, you may not move cells in the worksheet, the arrows may scroll the entire worksheet instead of being able to move cells. In this case, it becomes impossible to move cells. You may end up on the next spreadsheet instead of moving to the next cell. To fix the issue you have to follow the following five solutions.
Solution 1: Disable Scroll Lock in Excel
You may not be able to move your cursor if you accidentally turned on the Scroll lock. To fix the problem, you have to right-click on the Status bar at the bottom of your worksheet. On the status bar menu, select Scroll Lock once to turn it off.
Try moving cells on your worksheet using the arrow keys. They should work normally now. Then you will be able to solve the problem “unable to move cells in Excel”.
Solution 2: Using Keyboard Turn Off Scroll Lock
Excel cannot move cells if the Scroll Lock is turned on. In this case, the up and down arrow will not work until it has been turned off. A computer keyboard usually has a scroll key, and if the light for the key is on, this means the key is turned on. To turn it off, simply press the button once. By turning off the light of the button, you are also turning off Scroll Lock.
You can now move cells in Excel using the up and down arrow keys and everything should work normally and you will be able to solve the problem “unable to move cells in Excel”.
Read more: How to Move Cells in Excel with Keyboard
Similar Readings
Solution 3: Utilizing On-Screen Keyboard
Scroll Lock is not commonly found on modern laptops or PCs. The reason for this is that in the latest PC and laptop models this key was removed based on the belief that consumers rarely use it. If this is the case, use the on-screen keyboard to access all the keys, including those that aren’t available on a physical keyboard. You can also use the on-screen keyboard if any of the keys are damaged or do not work on the physical keyboard. Let’s walk through the steps to find out how to turn off the Scroll Lock key.
📌 Steps:
- Firstly, on your keyboard, press the ‘Win+R’ keys to access the Run command.
- Next, type OSK.EXE in the search field and click on OK.
- When the On-screen keyboard appears, you will see that the ScrLk button is blue, which means you enable it. To turn it off, click on the on-screen keyboard. The blue color should disappear.
Go to the worksheet you created in Excel and try to move your cells using the arrow keys.
Solution 4: Enable Sticky Keys
Here is another solution by turning on the sticky keys feature on your system if your MS Excel arrow not moving. Let’s walk through the steps to find out how to turn on the Sticky keys feature.
📌 Steps:
- Firstly, go to Start, and select Run from the menu.
- Next, type the control panel in the search field and click on OK.
- When the Control Panel window appears, go to the View by section and click on Ease of Access Centre.
- Next, the Ease of Acces Center window appears, click on the Make the keyboard easier to use option.
- When the Make the keyboard to easier to use window appears, check the Turn on Sticky Keys option.
Try moving cells on your worksheet using the arrow keys. They should work normally now.
Similar Readings
- How to Use the Arrows to Move Screen Not Cell in Excel
- How to Shift Cells Up in Excel
- How to Perform Double Click Cell Jump in Excel
Solution 5: Disable Add-ins
Occasionally, you may need to disable any installed Add-ins to solve the issue since Add-ins can interfere with the app’s functionality and cause issues with the arrow keys. Let’s walk through the steps to find out how to disable Add-Ins.
📌 Steps:
- Firstly, after opening the Excel file, click on the File tab.
- Next, click on More and then select options.
- When the Excel Options window appears, click on Add-ins, go to the Manage field and click on the Go button.
- When the Add-ins dialogue box appears, uncheck all the boxes and click on OK.
Try moving cells on your worksheet using the arrow keys. They should work normally now.
Read More: Move and Size With Cells in Excel
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
That’s the end of today’s session. I strongly believe that from now you may move cells in Excel. If you have any queries or recommendations, please share them in the comments section below.
Related Articles
- How to Shift Cells Right in Excel
- How to Move Filtered Cells in Excel
- How to Move Highlighted Cells in Excel
- How to Move a Group of Cells in Excel
- How to Shift Cells Down in Excel
- How to Shift Cells Down in Excel Without Changing Formula
- How to Move Down One Cell Using Excel VBA
- Move One Cell to Right Using VBA in Excel
- Fix: Excel Cannot Shift Nonblank Cells
- How to Move Cells in Excel Without Replacing