Others

How to Fix Excel for iPad Repeating First Row When Copying Multiple Rows

Amos Gikunda Sep 28, 2026 868 views

Question details

Users need to prevent Excel for iPad from unintentionally repeating and pasting the first row's data when attempting to select and copy multiple rows.

Fix Excel for iPad Repeating the First Row When Copying Multiple Rows

Product: Excel for iPad
Device & OS: iPadOS
Scenario: Selecting and copying multiple rows of data in a spreadsheet using the touch interface on an iPad.
Observed behavior: Pressing the selection handle activates the quick-copy (autofill) feature instead of just highlighting cells, which repeats the first row's data and overwrites the existing or blank rows below it.

Before you start

Tap the Undo button in the top ribbon immediately if your data has just been overwritten, and ensure you have a recent backup of your spreadsheet saved to iCloud or OneDrive.

Solution 1Recommended

Adjust Your Selection Handle Technique

Change how you interact with the green selection handles to prevent the quick-copy autofill feature from triggering.

The Excel for iPad interface uses the same green handles for both selecting multiple cells and activating the quick-copy (autofill) feature. Holding the handle for too long tells the app to fill the data downwards, causing the overwrite issue.

Select the first row

Tap once on the first row or cell you wish to include in your selection to bring up the green selection handles.

Drag quickly without holding

Place your finger on the lower green handle and drag it downward swiftly. Do not press and hold the handle before dragging, as this triggers the quick-copy behavior.

Copy the selection

Once the desired rows are highlighted normally, tap inside the highlighted area and select 'Copy' from the context menu, then paste it into your desired location.

Quick Recovery: If you accidentally activate quick-copy and overwrite your data, immediately tap the curved Undo arrow at the top left of your screen to restore the cells.

Solution 2

Update Excel and Submit Feedback

Keep your app updated to receive bug fixes for touch responsiveness, and report the issue to developers.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management on iPad

If Excel's touch selection handles continue to cause data overwrite issues on your iPad, WPS Office offers a highly compatible, free alternative. Enjoy a touch-optimized interface where selecting, copying, and pasting rows works smoothly without unexpected autofill glitches.

1. Download WPS Office: Search for WPS Office in the Apple App Store and install the free application on your iPad.
2. Open your spreadsheet: Launch WPS Office and open your existing Excel (.xlsx) files directly from your local storage or cloud drive.
3. Select and copy rows seamlessly: Tap and drag the selection handles to highlight multiple rows smoothly, then tap 'Copy' to safely duplicate your data without accidental overwrites.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsIntuitive and stable touch interface optimized specifically for iPadOSFree to use with powerful data entry, formatting, and calculation toolsLightweight app size with seamless cloud synchronization

microsoft office alternative - wps office

Frequently Asked Questions

Why does dragging the green dot in Excel overwrite my cells?

Pressing and holding the green selection handle in Excel for iPad activates the Autofill (quick-copy) feature. Instead of expanding your selection, it copies the content of the first cell downwards, overwriting any existing data in the rows below.

Can I disable the quick-copy handle in Excel for iPad?

Currently, Excel for iPad does not have a dedicated settings toggle to disable the quick-copy autofill handle. To avoid triggering it, you must adjust your gesture by dragging the handle swiftly rather than pressing and holding it.

How do I recover data that was just overwritten by quick-copy?

You can restore your overwritten data by immediately tapping the Undo button (the backward-pointing curved arrow) located in the top ribbon menu of the Excel app.

Is it possible to select multiple rows without using the handles?

Yes. You can tap on the row numbers on the far left side of the spreadsheet and drag your finger down across the numbers to highlight entire rows without interacting with the cell-level green selection handles.

Excel & Data Problems