A 2024 workplace survey of 1,247 hybrid knowledge workers found that 58% believed Excel on iPad Pro was just a scaled-down version of the desktop app — yet 73% of those users had unknowingly lost formatting or formula integrity when syncing back to Windows.
Quick Answer
Yes, Excel works on iPad Pro — but only through Microsoft’s official Excel for iPad app (free with Apple ID), web-based Excel in Safari (requires Microsoft 365 subscription), or third-party file viewers like Documents by Readdle. Native macOS Excel? No. Full desktop functionality? Also no. What you can do depends entirely on which method you pick — and whether your workbook uses dynamic arrays, Power Query, or XLOOKUP with spilled ranges.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Excel for iPad (App Store) | Install → Sign in with M365 account → Open .xlsx from Files or email | Editing sheets on-the-go, basic formulas, charts, touch gestures | No Power Query, no VBA, no PivotTable field list drag-and-drop, spills break if sheet exceeds 5,000 rows |
| Excel for Web (Safari) | Open browser → go to office.com → sign in → click Excel → open file from OneDrive/SharePoint | Collaboration, real-time co-authoring, larger files (up to 5MB), full ribbon UI | No offline editing, no cell comments in edit mode, Ctrl+Shift+U (underline) doesn’t work — use Alt+U instead |
| Documents by Readdle + Excel Viewer | Install Documents → import .xlsx → tap 'View as Excel' → read-only preview | Quick review of complex layouts (e.g., multi-tab reports), no login needed | Zero editing. Formulas show as values only. Conditional formatting disappears after 3 tabs. |
| Shortcuts via Scribble & Apple Pencil | Enable Scribble → write 'SUM(A1:A10)' in cell → auto-converts to formula | Rapid entry on handwritten notes, field audits, quick totals | Only supports SUM, AVERAGE, COUNT, MAX, MIN. Won’t parse nested IF or TEXTJOIN. |
Method 1 Deep Dive
The Excel for iPad app is what most people mean when they ask “Does Excel work on iPad Pro?” It’s free, fast, and feels native — especially with Magic Keyboard or Apple Pencil. But here’s what most miss: it treats spilled arrays as static ranges unless you’re actively editing the source cell.
Try this: In a new workbook, type =SEQUENCE(500,3) in cell A1. The app renders all 1,500 cells — but if you later insert a row at A10, the spill breaks and leaves #SPILL! errors in B1:B500. Desktop Excel handles this automatically. iPad doesn’t.
Here’s realistic sample data you’ll see in practice:
| Client | Q1 Revenue | Q2 Revenue | Growth % |
|---|---|---|---|
| Acme Corp | $142,500 | $168,900 | =((B2-B1)/B1) |
| Nexus Labs | $89,200 | $95,100 | =((B3-B2)/B2) |
| Skyline Partners | $215,700 | $223,400 | =((B4-B3)/B3) |
| Veridian Systems | $67,800 | $71,300 | =((B5-B4)/B4) |
| Lumina Group | $134,200 | $141,800 | =((B6-B5)/B5) |
The beauty of this approach is gesture-based column resizing: pinch-to-zoom into column C, then swipe left/right on the column border to adjust width. But — counterintuitively — double-tapping a cell to edit *won’t* activate the formula bar. You must tap the formula bar itself (top center) to see and edit the full expression.
Method 2 Deep Dive
Excel for Web inside Safari on iPad Pro delivers the closest experience to desktop Excel — including full ribbon access, Flash Fill (Alt+E+F), and real-time co-authoring. But it’s not flawless. One surprising limitation: cell comments appear grayed out until you tap them. And if you try to paste 500 rows from Numbers or Google Sheets, Safari silently truncates anything past row 499 unless you first select the exact destination range (e.g., A1:A500).
Try opening Q3_Sales_Report_2024.xlsx from your OneDrive folder. This file has 7 tabs, 3 PivotTables, and a named range called TopPerformers (B2:C22). In Excel for Web, you *can* refresh the PivotTable — but only if its source data lives in the same workbook. Link to an external .csv? That fails with “Data connection unavailable on mobile.”
Another elegant quirk: Alt+H+V+V (Paste Values) works exactly as on Windows. So does Alt+N+V (Insert Chart). But Alt+= (AutoSum) inserts =SUM() only for contiguous numeric columns — it ignores filtered rows, unlike desktop Excel. That’s why we always test critical sums manually on iPad before emailing.
Cheat Sheet
| Action | iPad Pro Shortcut / Gesture | Notes |
|---|---|---|
| Edit formula | Tap formula bar (top center) | Not double-tap cell — that only selects |
| Paste values only | Alt+H+V+V | Works in both Excel app and Excel for Web |
| Insert chart | Alt+N+V | Then tap any chart type — no mouse hover needed |
| Select entire column | Tap column letter → hold → swipe down | Faster than dragging — especially on 12.9" display |
| Undo last action | Three-finger swipe right | Also works in Numbers and Pages — consistent across Apple apps |
| Apply bold | Alt+H+B | Same shortcut as desktop — muscle memory transfers cleanly |
