The first thing most people do when they get an iPad and need to work with Excel files is open the App Store and search for ‘Microsoft Excel’. Then they tap Install, open it, and immediately hit a wall: formulas won’t recalculate after editing, PivotTables feel locked, and Ctrl+C/V doesn’t work — because they’re still thinking in Windows terms. That’s the mistake. You’re not missing Excel. You’re using the wrong mental model for how Excel lives on iPad.
Quick Answer
Yes — iPads have Excel, but not the full desktop version. You get Excel for iPad (a free app from the App Store), which supports editing, formulas, charts, and even basic Power Query — as long as you sign in with a Microsoft account. No subscription? You can view and make light edits, but saving changes requires a Microsoft 365 plan or one-time purchase of Office 2021 for Mac (which doesn’t install on iPad — more on that later).
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Excel for iPad (App Store) | Install from App Store → Sign in with Microsoft account → Open .xlsx file from Files, email, or OneDrive | Daily editing, collaboration, touch-first workflows | No VBA, limited array formulas, no Solver add-in |
| Web Excel via Safari | Go to excel.office.com → Sign in → Open workbook from OneDrive or upload | Complex formulas, large datasets (>50k rows), keyboard-heavy work | Requires stable Wi-Fi; no offline access; no touch gestures for cell selection |
| Files app + Quick Look | Tap .xlsx file in Files → Tap ‘…’ → ‘Quick Look’ → Tap ‘Edit in Excel’ if signed in | One-off edits without opening the full app | No formula bar visibility; can’t insert rows/columns easily |
| Shortcuts + External Keyboard | Connect Bluetooth keyboard → Use Alt+H+V+C to paste values (not formulas) | Power users who type faster than they tap | Alt key sequences differ from Windows (e.g., Alt+H+V+V = Paste Special → Values) |
| Export to Numbers & back | Open in Numbers → Edit → Share → Export as Excel (.xlsx) | Simple tables where Excel compatibility isn’t critical | Loses named ranges, dynamic arrays, and conditional formatting rules |
Method 1 Deep Dive
Let’s walk through editing a real sales report in Excel for iPad. Say you’ve got Sales_Q3_2024.xlsx saved in your OneDrive folder. It has 7 columns: A=Rep Name, B=Region, C=Product, D=Units Sold, E=Unit Price, F=Revenue (D*E), G=Commission (F*0.07). Rows 2–11 hold data — including Sarah Chen (West, Widget Pro, 14 units, $299), and Marcus Lee (East, NanoGadget, 8 units, $449).
Open Excel for iPad → tap the folder icon at bottom → select OneDrive → tap Sales_Q3_2024.xlsx. You’ll see the grid. Try tapping cell F2 — the formula bar shows =D2*E2. Good. Now try changing D2 from 14 to 16. F2 updates instantly. But here’s the surprise: if you copy F2 and paste into F12, Excel for iPad pastes the formula, not the value — unless you hold the paste icon and choose ‘Paste Values Only’. (Trust me, I learned this the hard way during a client demo.)
Now try inserting a new row: tap the row number (say, row 5) → tap the ‘+’ that appears → choose ‘Insert Row Above’. The formula in F5 auto-updates to =D5*E5. But — and this is critical — if you type =SUM(F2:F11) in F12, it works. Type =SORT(F2:F11)? Nope. Dynamic arrays aren’t supported yet. So instead, you’d sort manually: tap the column header F → ‘Sort Ascending’ → confirm.
One more tip: swipe right on the ribbon to reveal ‘Data’ tab. Tap ‘What-If Analysis’ → ‘Goal Seek’. It’s there — but only if your workbook is saved to OneDrive *and* you’re signed into a Microsoft 365 plan. Without it, the button is grayed out.
Method 2 Deep Dive
Web Excel gives you the closest experience to desktop — especially if you’re used to keyboard navigation. Open Safari → go to excel.office.com → sign in. Upload Sales_Q3_2024.xlsx or open from OneDrive.
You’ll notice the ribbon looks identical to desktop Excel — and it responds to real shortcuts. Try selecting B2:B11 (Region column), then press Alt+H+L. Boom — Fill Color menu opens. Press Alt+H+V+C to paste values only. That shortcut works exactly like Windows — no remapping needed. (Yes, really. Apple’s WebKit now fully supports Alt key combos in Safari on iPadOS 17+.)
Here’s what’s different: pinch-to-zoom works, but dragging the scroll bar with your finger feels sluggish. Better to use the scroll wheel on a Magic Keyboard or swipe with two fingers on the trackpad. Also — and this trips up everyone — double-tapping a cell enters edit mode, but tapping the formula bar *doesn’t*. You must tap inside the cell first.
Try this: select A1:G11 → press Ctrl+T (or Cmd+T) → confirm ‘My table has headers’. Now go to the ‘Design’ tab → check ‘Total Row’. A new row appears at the bottom. Click the cell under ‘Revenue’ → dropdown shows SUM, AVERAGE, COUNT — pick SUM. It inserts =SUBTOTAL(109,[Revenue]) — same as desktop. This is where web Excel shines: full function support, no arbitrary cutoffs on row count, and real-time co-authoring with desktop users.
But don’t assume offline access. Close Safari, turn off Wi-Fi, and reopen the tab? You’ll get ‘No internet connection’ — even if the file was open moments before. Web Excel saves automatically, but it never caches full workbooks locally.
Cheat Sheet
| Task | iPad App Shortcut | Web Excel Shortcut | Notes |
|---|---|---|---|
| Paste Values Only | Hold paste icon → ‘Paste Values Only’ | Alt+H+V+V | Web version matches desktop behavior |
| Insert Row Above | Tap row number → ‘+’ → ‘Insert Row Above’ | Ctrl+Shift++ (plus) | No equivalent in iPad app — must use menu |
| Apply Bold | Select cells → tap ‘B’ on ribbon | Ctrl+B | Works in both, but iPad needs ribbon visible |
| Open Format Cells | Select → tap ‘Home’ → ‘Format’ → ‘Format Cells’ | Ctrl+1 | Web version shows full dialog; iPad shows simplified panel |
| Save As New File | File → ‘Save As’ → Choose location | File → ‘Save As’ → OneDrive/Download | Both require Microsoft account sign-in |
