Fix Excel for iPad Dragging Cells Instead of Moving Them
Question details
The user needs to resolve an issue in Excel for iPad where dragging cells results in copying them rather than moving them.
- Product
- Excel for iPad
- Device & OS
- iPadOS
- Scenario
- Moving cell, row, or column contents using the touch drag-and-drop feature in the Excel app on an iPad.
- Observed behavior
- The app copies the contents instead of moving them, often displaying a green plus sign to incorrectly indicate a copy operation.
Ensure your iPad is connected to a stable Wi-Fi network and has sufficient battery life, as you will need to download application updates from the App Store.
Update Excel for iPad to the Latest Version
This issue is a known bug that was addressed in a subsequent release. Updating the app is the most effective way to restore standard drag-and-drop functionality.
Microsoft identified this copy-instead-of-move glitch and has deployed a patch to resolve it. Installing the newest version from the App Store will automatically apply this fix.
Navigate to your iPad's home screen and tap the App Store icon to launch the application.
Tap on your profile picture located in the top-right corner of the App Store screen to view your account details and available app updates.
Scroll down to find Microsoft Excel in the list of pending updates. Tap the 'Update' button next to the app name to begin downloading the patch.
Once the update finishes installing, open Excel, tap to select a cell, and try dragging it to confirm it now moves instead of copies.
Use Cut and Paste as a Temporary Workaround
If you cannot update the Excel app immediately, using the cut and paste commands will successfully move your data without copying it.
Try WPS Office for iPad for Seamless Spreadsheet Editing
If you continue to experience bugs like the dragging issue in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative for managing spreadsheets on your iPad without the frustrating glitches.
Frequently Asked Questions
Why does a green plus sign appear when I drag cells in Excel for iPad?
The green plus sign is a visual indicator that the app is interpreting your drag action as a command to copy the data rather than move it. This was an identified software bug in specific older versions of Excel for iPad.
Will reinstalling the Excel app fix the drag-and-drop bug?
Yes, uninstalling and reinstalling the app from the App Store will ensure you have the absolute latest version installed, which includes the necessary patch for this issue. Be sure your files are synced to OneDrive before uninstalling.
How do I properly select and move cells on an iPad without a mouse?
To move a cell in an updated app, tap it once to select it, then tap and hold the border of the selection box until it visually lifts. You can then smoothly drag the cell to your desired location.
