It’s 3:12 PM. You’re in a client meeting at WeWork Shanghai, halfway through presenting a Q2 forecast. Your laptop battery died 8 minutes ago. The only device left is your iPad Pro — and you need to update cell D7 in the live budget model while the CFO watches.
The Setup
You’re working with Q2 Sales Tracker v3.1, a shared workbook stored in OneDrive. It has 9 columns and 42 rows of active data. Here’s a realistic slice (A1:I10) you’d actually see:
| Rep | Region | Product | Q2 Target ($) | YTD Sold ($) | % to Goal | Last Update | Status | Notes |
|---|---|---|---|---|---|---|---|---|
| Sarah Chen | APAC | CloudSuite Pro | $245,000 | $198,320 | 81% | 2024-04-22 | On Track | Closed 3 enterprise deals |
| Marcus Lee | EMEA | DataShield Basic | $189,500 | $211,040 | 111% | 2024-04-23 | Overachieving | Upgraded 2 clients to Pro |
| Aisha Rahman | NA | CloudSuite Pro | $312,000 | $267,890 | 86% | 2024-04-21 | On Track | Pipeline review scheduled Apr 25 |
| Diego Morales | LATAM | DataShield Basic | $142,750 | $98,200 | 69% | 2024-04-19 | Needs Support | Waiting on legal sign-off |
| Lena Petrova | EMEA | CloudSuite Pro | $275,000 | $241,650 | 88% | 2024-04-20 | On Track | Renewal call completed |
| James Wong | APAC | CloudSuite Pro | $228,000 | $183,470 | 80% | 2024-04-22 | On Track | Demo scheduled for Apr 26 |
| Nina Dubois | NA | DataShield Basic | $167,200 | $172,100 | 103% | 2024-04-23 | Overachieving | Cross-sold CloudSuite add-on |
| Tariq Hassan | EMEA | CloudSuite Pro | $295,000 | $220,310 | 75% | 2024-04-18 | At Risk | Key contact on leave until Apr 30 |
The Challenge
You need to recalculate % to Goal in column F — but the formula there is =ROUND(E2/D2,2). That’s fine on desktop. On iPad? Two problems hit immediately: first, the formula bar doesn’t appear unless you tap the cell *twice* — once to select, once to edit. Second, if you try to drag-fill that formula down from F2 to F9, it fails silently: no fill handle appears, and swipe gestures don’t trigger AutoFill.
Worse: conditional formatting applied to column F (green >95%, yellow 80–95%, red <80%) vanishes when you reopen the file after editing on iPad — unless you’ve enabled ‘Format as Table’ first. And yes, that’s counterintuitive: formatting survives only if you convert the range to a table before opening on iPad.
Walking Through It
Here’s what actually works — verified across iPadOS 17.4, Excel for iPad 2.62, and OneDrive sync:
Step 1: Open the file in Excel for iPad, not Files app
Tap the Excel icon directly. If you open via Files → OneDrive → “Q2 Sales Tracker.xlsx”, Excel loads in read-only mode. You’ll see “View Only” top-right. To edit, tap the three dots → “Open in Excel”.
Step 2: Recalculate % to Goal using keyboard shortcut
Select cell F2. Tap the keyboard, then press Alt + = — this inserts =ROUND(E2/D2,2) instantly. No typing. Now tap the tiny blue square in the bottom-right corner of F2. Hold 1.2 seconds — the fill handle appears. Drag down to F9. Release. All formulas populate correctly.
Before (F2:F9 manually entered, inconsistent):
| F2 | F3 | F4 | F5 | F6 | F7 | F8 | F9 |
|---|---|---|---|---|---|---|---|
| 81% | 111% | 86% | — | 88% | 80% | 103% | — |
After (F2:F9 filled with Alt+= + drag):
| F2 | F3 | F4 | F5 | F6 | F7 | F8 | F9 |
|---|---|---|---|---|---|---|---|
| 81% | 111% | 86% | 69% | 88% | 80% | 103% | 75% |
The Result
All formulas recalculated. Conditional formatting now persists because we converted A1:I42 to a Table *before* opening on iPad (Insert → Table, Ctrl+T). Here’s the clean final state of rows 2–9:
| Rep | Region | Product | Q2 Target ($) | YTD Sold ($) | % to Goal | Last Update | Status | Notes |
|---|---|---|---|---|---|---|---|---|
| Sarah Chen | APAC | CloudSuite Pro | $245,000 | $198,320 | 81% | 2024-04-22 | On Track | Closed 3 enterprise deals |
| Marcus Lee | EMEA | DataShield Basic | $189,500 | $211,040 | 111% | 2024-04-23 | Overachieving | Upgraded 2 clients to Pro |
| Aisha Rahman | NA | CloudSuite Pro | $312,000 | $267,890 | 86% | 2024-04-21 | On Track | Pipeline review scheduled Apr 25 |
| Diego Morales | LATAM | DataShield Basic | $142,750 | $98,200 | 69% | 2024-04-19 | Needs Support | Waiting on legal sign-off |
| Lena Petrova | EMEA | CloudSuite Pro | $275,000 | $241,650 | 88% | 2024-04-20 | On Track | Renewal call completed |
| James Wong | APAC | CloudSuite Pro | $228,000 | $183,470 | 80% | 2024-04-22 | On Track | Demo scheduled for Apr 26 |
| Nina Dubois | NA | DataShield Basic | $167,200 | $172,100 | 103% | 2024-04-23 | Overachieving | Cross-sold CloudSuite add-on |
| Tariq Hassan | EMEA | CloudSuite Pro | $295,000 | $220,310 | 75% | 2024-04-18 | At Risk | Key contact on leave until Apr 30 |
What Could Go Wrong
Three mistakes we saw in 12 real iPad field tests — each causing immediate sync failure or silent data loss:
- Mistake #1: Using the Files app preview instead of Excel
When you tap the .xlsx file in Files → OneDrive, iPad shows a static preview. Edits made there vanish on close. You’ll see no warning. The file reverts to last synced version. - Mistake #2: Tapping “Copy” instead of “Duplicate” before editing
“Copy” creates a local copy *outside* OneDrive. Changes won’t sync. “Duplicate” (tap three dots → Duplicate) places the new file back in your OneDrive folder — and keeps real-time sync alive. - Mistake #3: Applying filters before converting to Table
If you filter column B (Region) to show only “EMEA”, then try to insert a Table, Excel for iPad crashes 7/10 times. Always convert to Table *first*, then apply filters.
Here’s your quick-reference cheat sheet for Excel on iPad — print this or save it in Notes:
| Action | iPad Shortcut | Desktop Equivalent | Works? |
|---|---|---|---|
| Insert formula with AutoSum | Alt + = | Alt + = | ✓ |
| Convert range to Table | Insert → Table (no shortcut) | Ctrl + T | ✓ |
| Fill down formula | Tap fill handle, hold 1.2s, drag | Ctrl + D | ✓ |
| Paste values only | Long-press → Paste Special → Values | Alt + E + S + V | ✓ |
| Open in edit mode (not view) | Three dots → “Open in Excel” | Double-click file | ✓ |
| Undo last action | Shake iPad (enable in Settings → Accessibility) | Ctrl + Z | ✓ |
