How to Fix Cannot Drag and Drop Cells in Excel on iPad
Question details
The user is unable to use the drag-and-drop touch gesture to move cells within any Excel workbook on their iPad.
- Product
- Microsoft Excel
- Device & OS
- iPadOS
- Scenario
- Attempting to reorganize data by dragging and dropping selected cells in a spreadsheet using iPad touch controls.
- Observed behavior
- The drag-and-drop feature is completely unresponsive across all workbooks, a problem that persists even after uninstalling and reinstalling the Excel application.
Ensure your iPad screen is clean and verify that touch gestures and dragging functions are working properly in other apps to rule out a hardware issue.
Check for Excel and iPadOS Software Updates
Since this issue is likely caused by a bug in a recent software update, installing the latest patches for both the app and the operating system is the most effective solution.
Microsoft frequently releases patches to fix bugs reported by users. If a previous update broke the drag-and-drop functionality, a subsequent update will typically resolve it.
Open the App Store on your iPad, tap your profile icon at the top right, scroll down to check for available updates, and tap 'Update' next to Microsoft Excel.
Go to the Settings app, tap 'General', and select 'Software Update'. If an update is available, tap 'Download and Install'.
After updating, restart your iPad to ensure all new system and app configurations are properly loaded before testing the drag-and-drop feature.
Use the Cut and Paste Workaround
While waiting for a permanent bug fix from Microsoft, you can manually move cells using the standard iOS context menu.
Report the Issue to Microsoft Support
Submitting a detailed bug report directly from the app helps developers identify widespread issues and prioritize a fix.
Use WPS Office for iPad as a Reliable Alternative
If Excel updates are causing frustrating workflow interruptions, switch to WPS Office. It provides a highly compatible, touch-optimized spreadsheet experience on iPad without the buggy updates or expensive subscription fees.
- 1. Download from the App Store: Open the App Store on your iPad, search for WPS Office, and download the app for free.
- 2. Open Your Excel File: Launch WPS Office, browse to your existing .xlsx workbook, and open it directly without any conversion.
- 3. Manage Cells with Ease: Enjoy responsive touch controls to highlight, move, and edit your spreadsheet data smoothly.
Frequently Asked Questions
Why did drag and drop suddenly stop working in Excel on my iPad?
This issue is typically caused by a bug introduced in a recent Microsoft Excel app update or an incompatibility with the latest iPadOS version. Reinstalling often doesn't help until the developers release a specific patch.
Is there a specific setting to enable drag and drop in Excel for iPad?
Unlike the desktop version of Excel, the iPad application relies on standard system-wide iOS touch gestures. There is no dedicated toggle switch within the Excel app settings to turn drag and drop on or off.
Does this issue affect other Microsoft Office apps on the iPad?
It can. If the bug is related to a shared Microsoft Office core update on iPadOS, you might also experience touch gesture issues in apps like Word or PowerPoint. Testing those apps can help determine the scope of the bug.
How can I move multiple cells without dragging and dropping?
You can highlight multiple cells by dragging the selection handles (the dots at the corners of the selected cell), tapping the highlighted area, choosing 'Cut' from the pop-up menu, and then pasting it into the new location.
