How to Fix Excel Cells Not Being Able to Move: 5 Solutions

Solution 1 – Disabling Scroll Lock in Excel

Steps:

  • Right-click on the Status bar at the bottom of the worksheet.
  • Select Scroll Lock to turn it off.

unable to move cells in excel.


Solution 2 – Using the Keyboard to Turn Off Scroll Lock

Steps:

  • Press the Scroll Lock

Read more: How to Move Cells in Excel with Keyboard


Solution 3 – Utilizing the On-Screen Keyboard

Steps:

  • Press the ‘Win+R’ keys to access the Run command.
  • Enter OSK.EXE in the search field and click OK.

Utilizing On-Screen Keyboard

  • The On-screen keyboard appears. If the ScrLk button is blue, it’s enabled. To turn it off, click the on-screen keyboard. The blue color should disappear.

Unable to Move Cells in Excel


Solution 4 – Enabling Sticky Keys

Steps:

  • Go to Start, and select Run from the menu.

Enable Sticky Keys

  • Enter the control panel in the search field and click OK.

  • When the Control Panel window appears, go to the View by section and click Ease of Access Center.

Unable to Move Cells in Excel

  • Click on the Make the keyboard easier to use option.

Enable Sticky Keys

  • Select the Turn on Sticky Keys option.

Unable to Move Cells in Excel


Solution 5 – Disabling Add-ins

Steps:

  • Click on the File tab.

Disable Add-ins

  • Click on More and select Options.

  • Click Add-ins, go to the Manage field, and click the Go button.

Unable to Move Cells in Excel

  • Uncheck all the boxes and click OK.

Disable Add-ins


Download Practice Workbook

Download this workbook to practice the exercises.


Related Articles


<< Go Back to Move Cells | Excel Cells | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo