Fix Copy and Paste Formatting in Excel for iOS
Question details
The user needs to copy and paste cell formatting and formulas reliably 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.
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.
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.
On your iPad, open the App Store and search for Microsoft Excel.
Tap Update if it is available. Install version 2.1 or the latest release compatible with your iPad.
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.
Turn off Speak Selection to isolate the issue
Try this accessibility setting if the issue continues after updating Excel.
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.

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.




