It’s 3:12 PM. You’re in a client conference room at Acme Corp’s Shanghai office. The presenter just handed you an iPad to review last-minute budget adjustments—and you realize the file is an .xlsx. You tap it. It opens… but formulas won’t recalculate. Charts won’t resize. And your Alt+= shortcut? Doesn’t exist.
Quick Answer
No, the iPad doesn’t have the full Excel desktop program—but yes, it runs Microsoft Excel for iPad, a native app with strong editing capabilities (including pivot tables and XLOOKUP) if you have a Microsoft 365 subscription. Free access lets you view and make light edits, but saving changes or using advanced functions requires a paid plan.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Excel for iPad (App Store) | Install from App Store → Sign in with Microsoft 365 account → Open file from Files app or OneDrive | Real-time collaboration, offline edits, touch-optimized charts | No VBA, no Power Query editor, no Solver add-in |
| iCloud + Numbers | Save Excel file to iCloud Drive → Open in Numbers → Export back as .xlsx (if needed) | Quick formatting fixes when Excel app isn’t available | Formula mismatches (e.g., =XLOOKUP becomes =LOOKUP), lost conditional formatting in B2:C10 |
| Excel Online (Safari) | Open Safari → go.office.com → sign in → open file from OneDrive or SharePoint | Larger worksheets (>10k rows), complex data validation rules | No copy-paste between apps, sluggish scrolling on older iPads, no pinch-to-zoom in formula bar |
| Third-party app (Polaris Office) | Download Polaris → import .xlsx → edit → export to OneDrive | Users without Microsoft 365, legacy Excel 97–2003 files | No dynamic arrays, crashes on files with >3 pivot tables, can’t open encrypted .xlsx |
| Desktop Remote (Microsoft Remote Desktop) | Install Remote Desktop app → connect to Windows PC → launch Excel.exe remotely | Running macros, Power Pivot models, or custom ribbon tabs | Requires constant Wi-Fi, high latency on cellular, no Apple Pencil support for drawing shapes |
Method 1 Deep Dive
Let’s say you’re reviewing Q1 sales data from Sarah Chen (Regional Manager, Acme Corp). She sent Sales_Q1_2024.xlsx. You open it in Excel for iPad.
First, check row 1: headers are A1=Region, B1=Product, C1=Units Sold, D1=Revenue. Values start at A2. Total revenue is calculated in cell D22 with =SUM(D2:D21).
Now try updating B5 from "Wireless Headset" to "Wireless Headset Pro". Tap the cell → type → tap the green checkmark. Done. But here’s the surprise: if you change C5 from 124 to 137, D5 won’t auto-update—even if it contains =C5*E5 and E5 holds price ($89.99). Why? Because Excel for iPad doesn’t recalculate formulas automatically after single-cell edits unless you force it.
The fix: Tap the Formulas tab → tap Calculate Now (or use the keyboard shortcut Alt+Shift+F9 — yes, it works with Bluetooth keyboards). Or better: go to Settings → Options → Calculation → Automatic. That setting sticks across files.
Sample data from that sheet:
| Region | Product | Units Sold | Revenue |
|---|---|---|---|
| North Asia | Wireless Headset | 124 | $11,147.76 |
| Southeast Asia | Smart Watch S2 | 89 | $13,439.00 |
| Greater China | Wireless Headset | 217 | $19,508.30 |
| North Asia | Smart Watch S2 | 152 | $22,952.00 |
| Southeast Asia | Wireless Headset | 93 | $8,360.70 |
Method 2 Deep Dive
You’re stuck with only Numbers installed—no Microsoft account, no subscription. You need to adjust forecast numbers in Forecast_Q2_2024.xlsx, specifically column F (Projected Revenue), based on new growth assumptions in cell H1 (=1.07).
Open the file in Numbers. You’ll see the formula in F2 reads =E2*H1. Good. But tap H1 and change it to 1.09. Nothing updates. That’s because Numbers doesn’t honor Excel’s relative/absolute reference logic fully.
Here’s what actually works: select F2:F25, tap the formula bar, and manually replace H1 with $H$1 — then tap Done. Now changing H1 will ripple correctly. (This is the counterintuitive part: Numbers *requires* explicit absolute references for cross-cell dependencies, unlike Excel.)
Also: avoid pasting from Notes or Messages into Numbers. Formatting breaks. Instead, paste into a plain-text editor first, then copy again. And never drag-fill more than 20 rows at once—Numbers freezes on iPad Air 3rd gen.
Cheat Sheet
| Action | Excel for iPad | Excel Online (Safari) | Numbers |
|---|---|---|---|
| Recalculate all formulas | Formulas tab → Calculate Now (or Alt+Shift+F9) |
F9 key (with keyboard) or Page Refresh |
Edit → Recalculate All |
| Select non-contiguous ranges | Tap first range → hold ⌘ → tap second | Not supported | Hold ⌘ → tap cells individually |
| Insert row/column | Tap row/column header → + icon | Right-click header → Insert | Tap table → Add Row/Column |
| Apply filter | Data tab → Filter → toggle on | Data tab → Filter (same UI) | Table → Filter → Enable |
| Save & sync to OneDrive | Auto-saves every 2 mins (if online) | Manual Save required (Ctrl+S) | Export → Location → OneDrive |
