Excel Performance Problems

Fix Excel for iPad Copying First Row Over Selected Rows

Maira Mehtab Sep 22, 2026 868 views

Question details

The user needs to prevent Excel for iPad from duplicating the first selected row into subsequent rows and overwriting existing data when selecting multiple rows.

Product: Microsoft Excel for iPad
Device & OS: iPadOS
Scenario: Selecting and copying multiple entire rows in the Excel app on an iPad.
Observed behavior: Excel intermittently or consistently duplicates the first row's data into every subsequent selected row, overwriting the existing data because of an unintended quick-copy trigger.

Before you start

Ensure your iPad touch screen is clean to prevent unintended long-press gestures, and verify that you have the latest version of Excel for iPad installed from the App Store.

Solution 1Recommended

Avoid Triggering the Quick-Copy Mechanism

Adjust your touch gestures to prevent activating Excel's quick-copy (auto-fill) handle, which is responsible for the overwriting behavior.

The overwriting issue is typically caused by Excel's quick-copy feature. When you press and hold the selection handle on a touch device, Excel assumes you want to fill the contents of the active cell or row into the adjacent selection. By modifying how you drag the handles, you can safely select multiple rows without triggering data duplication.

Select the Initial Row

Tap once on the row number header (on the far left side of the screen) to highlight the entire first row you want to select.

Locate the Selection Handle

Look for the small circular selection handle that appears at the corner of the green bounding box surrounding the selected row.

Drag Without Holding

Quickly tap and drag the selection handle down or up to highlight additional rows. Do not press and hold the circle before dragging, as a long press is the exact gesture that activates the quick-copy duplication.

Submit App Feedback: If you find this touch gesture overly sensitive, use the Help & Feedback option within the Excel for iPad app to report the issue directly to Microsoft, which may prompt UI improvements in future updates.

Free Microsoft Office alternative

Try WPS Office for iPad for Flawless Spreadsheet Editing

If Excel for iPad's touch gestures are causing unintended data loss or frustration, consider switching to WPS Office. It offers a highly intuitive touch interface for iPadOS, ensuring accurate row selection without accidental overwriting.

1. Install WPS Office: Download and install WPS Office for free from the Apple App Store on your iPad.
2. Open Your Spreadsheet: Launch WPS Office and tap the 'Open' icon to locate and load your existing Excel (.xlsx) file.
3. Select Rows Freely: Tap on the row header and gently drag the selection handle to highlight multiple rows without triggering any forced auto-fill gestures.

Seamlessly open, edit, and save Microsoft Excel (.xlsx, .xls) files without formatting loss.Intuitive and precise touch controls designed specifically for mobile and iPadOS devices.Free, lightweight, and fast alternative to Microsoft Office.Built-in cloud sync support to easily manage your spreadsheets across all devices.

Frequently Asked Questions

Why does Excel for iPad overwrite my rows when I select them?

This happens when you accidentally trigger the 'quick-copy' or 'fill' feature by pressing and holding the green selection handle before dragging. This specific touch gesture tells the app to copy and paste the contents of the first row into the newly selected rows.

How can I undo the accidental overwrite in Excel for iPad?

You can tap the curved 'Undo' arrow located at the top menu bar of the Excel app interface immediately after the data is overwritten to restore your original row data.

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

Currently, Microsoft does not provide a settings toggle to turn off the quick-copy (fill handle) feature in Excel for iPad. You must rely on adjusting your touch gestures to avoid triggering it.

Excel & Data Problems