Formatting Issues

Fix Copy and Paste Formatting in Excel for iOS

Camila MilosovichCamila Milosovich Nov 20, 2026 868 views

Question details

The user needs to copy and paste cell formatting and formulas reliably in Excel for iOS.

Fix Copy and Paste Formatting in Excel for iOS
Product
Microsoft Excel for iOS
Device & OS
iPad running iOS 10.3.1
Scenario
Copying a column or cell range and pasting it elsewhere in an Excel workbook.
Observed behavior
After the Excel 2.0.3 update, pasted cells can lose formulas and alignment even though conditional formatting is copied. An empty row may also be omitted.
Before you start

Check your Excel version and confirm that your iPad can install a newer compatible release from the App Store. Use a small range containing both formulas and formatting to test the result.

Solution 1Recommended

Update Excel for iOS and test copy and paste

Use this solution for the copy-and-paste issue reported in Excel version 2.0.3; it was addressed in version 2.1.

1
Open the App Store

On your iPad, open the App Store and search for Microsoft Excel.

2
Update Excel

Tap Update if it is available. Install version 2.1 or the latest release compatible with your iPad.

3
Test a cell range

Open your workbook in Excel, select a range containing formulas and formatting, and tap Copy. Select a destination and tap Paste, then check the formulas and alignment.

If no update is available: A newer Excel release may require a newer iPadOS version. Check the app's compatibility requirements in the App Store.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet files. Its Excel format compatibility helps you move existing workbooks into WPS, although it does not fix Excel for iOS itself.

Copy and paste spreadsheet cells while working in WPS SpreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for an easier transitionAccess a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Which Excel version fixed the reported iOS copy-and-paste issue?

Microsoft reported that the issue was fixed in Excel for iOS version 2.1. Search for Microsoft Excel in the App Store and install the latest update compatible with your iPad.

Where is Speak Selection on an iPad?

On iOS 10.3.1, go to Settings > General > Accessibility > Speech. On newer iPadOS versions, look under Settings > Accessibility > Spoken Content.

Why are formulas missing after I paste cells?

The reported Excel 2.0.3 issue could cause formulas and alignment to be lost while conditional formatting was copied. Update Excel, then copy and paste a small test range to check the result.

What if the App Store does not offer an Excel update?

Check the Microsoft Excel App Store listing for its iPadOS compatibility requirements. Your iPad may need a newer system version to install a newer Excel release.