Data Import & Export

Preserve Blank Cells When Copying in Excel for iPad

Amos GikundaAmos Gikunda Nov 22, 2026 868 views

Question details

The user wants to preserve blank cells and row order when copying a column between worksheets.

Preserve Blank Cells When Copying in Excel for iPad
Product
Microsoft Excel for iPad
Device & OS
iPadOS
Scenario
A column containing both values and blank cells is copied from one worksheet and pasted into another.
Observed behavior
Blank cells may disappear during a normal paste, shifting the remaining values out of their original positions.
Before you start

Check that the copied selection includes the full range, including the blank rows, and select the intended starting cell on the destination worksheet. Decide whether you need editable cells or only a visual copy of the original layout.

Solution 1Recommended

Use Paste Special to preserve the visible layout

Use this temporary workaround when preserving the order and appearance is more important than editing the pasted cells.

1
Copy the full range

On the source worksheet, select the cells containing both values and blanks, then tap Copy.

2
Open the paste options

Switch to the destination worksheet, tap the starting cell, and open Paste Special from the paste menu if it is available.

3
Check the result

Choose an available Paste Special option and compare the pasted result with the source range. In the reported case, Paste Special preserved the order by pasting the selection as a picture.

Use Paste Special to preserve the visible layout
A picture is not editable cell data: If the result is pasted as a picture, its contents cannot be edited as individual worksheet cells. Paste options may vary by Excel version.
Free Microsoft Office alternative

Try WPS Office for Worksheet Editing on iPad

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Excel format compatibility for easier migration. Try copying your range between worksheets in WPS Spreadsheets; it does not fix the Microsoft Excel app or guarantee identical paste behavior.

Copy and edit spreadsheet ranges across worksheetsOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceWork in a lightweight office suite with free features
QA img-9

Frequently Asked Questions

Why do blank cells disappear when I paste between worksheets?

In the reported Excel for iPad issue, blank cells may be omitted during the cross-sheet copy and paste process, causing values to shift. The exact cause was not confirmed.

Can Paste Special keep the cells editable?

Check the available options under the destination cell's paste menu. In the reported case, Paste Special preserved the order as a picture, not as editable cells.

How can I report this issue in Excel for iPad?

Open Excel's account or settings menu and look for Help or Feedback. Describe the source range, destination worksheet, and resulting shift, and attach screenshots if possible.

Will WPS Office fix the paste behavior in Microsoft Excel?

No. WPS Office is a separate app. You can try the same copy-and-paste task in WPS Spreadsheets, but it does not change how Excel for iPad handles the clipboard.