'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Cannot Drag or Move Cells in Excel for the Web
Question details
Users are unable to drag or move cells and rows in Excel for the web, typically when accessed via SharePoint.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Collaborating on online workbooks where moving cells or rows using the mouse cursor is required.
- Observed behavior
- The hand cursor does not appear when hovering over cell borders, preventing users from dragging or moving cells. This issue sometimes affects only specific accounts or specific sections of a shared workbook.
Ensure you have full edit permissions for the shared SharePoint workbook and verify your internet connection is stable before troubleshooting.
Unfreeze Panes Across All Worksheets
Frozen panes can interfere with the drag-and-drop functionality in Excel for the web. Removing them often restores the hand cursor.
In many cases, the drag-and-drop hand cursor is suppressed when frozen panes are active. You must ensure that all panes are unfrozen, including those on worksheets that might be currently hidden.
Log in to SharePoint and open your affected workbook in Excel for the web.
Right-click any visible sheet tab at the bottom, select Unhide, and reveal any hidden sheets to ensure you check the entire workbook.
Navigate to the View tab on the top ribbon, click on Freeze Panes, and select Unfreeze Panes for every worksheet in the document.
Refresh your web browser and try hovering over a cell border to see if the hand cursor reappears.
Test Alternative Browsers and Clear Cache
Browser-specific glitches or outdated cache data can cause the drag handle cursor to fail to load.
Report Account-Specific Issues to Microsoft
If the issue persists for specific users in a shared document while others can drag cells normally, it may be a backend Microsoft 365 account glitch.
Try WPS Office for Seamless Spreadsheet Management
If Excel for the web continues to experience dragging and dropping glitches on SharePoint, consider switching to WPS Office. It provides a highly compatible, lightweight, and stable alternative for all your spreadsheet needs without browser-related limitations.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite to your computer.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your downloaded .xlsx file directly to start editing.
- 3. Drag and Drop Freely: Select any cell or row and use the mouse to seamlessly drag and drop content without lag or missing cursors.
Frequently Asked Questions
Why does the hand cursor disappear in Excel for the web?
The hand cursor can disappear due to frozen panes, hidden sheets with active frozen panes, browser cache conflicts, or specific account glitches within the Microsoft 365 online environment.
Does the drag and drop issue affect the desktop version of Excel?
Typically, this specific cursor issue is isolated to Excel for the web (accessed via a browser or SharePoint). The desktop application handles drag-and-drop operations much more reliably.
How can I move cells if the drag function is currently broken?
As a temporary workaround, you can select the cells, press Ctrl+X to cut them, click the destination cell, and press Ctrl+V to paste. Alternatively, you can right-click and use the 'Insert Cut Cells' option.
How do I unhide a worksheet in Excel for the web to check for frozen panes?
Right-click any visible sheet tab at the bottom of the screen and select 'Unhide'. Choose the hidden sheet from the list and click OK to reveal it, then proceed to the View tab to unfreeze panes.
