Does Excel really work on your Android tablet? Does it open your .xlsx files without mangling formulas? Does it let you edit a pivot table or just scroll and squint?
The answer isn’t yes or no. It’s: yes — if you know which app you’re using, which file format you saved in, and where your cloud sync is actually pointing.
The Setup
You’re managing vendor payments for a small logistics firm. Your source file is Vendors_Q2_2024.xlsx, last edited on a Windows laptop. It has 9 rows of real vendor data — no dummy names, no placeholder values.
| Vendor ID | Company Name | Invoice Date | Amount ($) | Status |
|---|---|---|---|---|
| V-782 | Nexus Freight Ltd. | 2024-04-02 | $12,450 | Paid |
| V-783 | Blue Ridge Logistics | 2024-04-05 | $8,920 | Pending |
| V-784 | Acme Corp Supply Chain | 2024-04-07 | $15,300 | Paid |
| V-785 | TerraLink Distribution | 2024-04-10 | $6,710 | Overdue |
| V-786 | Summit Haulage Group | 2024-04-12 | $11,840 | Pending |
| V-787 | Orion Transit Solutions | 2024-04-14 | $9,260 | Paid |
| V-788 | Coastal Express Co. | 2024-04-16 | $13,090 | Overdue |
| V-789 | Veridian Load Services | 2024-04-18 | $7,430 | Pending |
| V-790 | Aurora Freight Partners | 2024-04-20 | $10,500 | Paid |
This sheet lives in OneDrive. You saved it from Excel for Microsoft 365 (desktop) as .xlsx, not .xlsb or .csv. Cell B2 contains "Blue Ridge Logistics". Cell D5 holds "$6,710". The Status column uses conditional formatting (green = Paid, yellow = Pending, red = Overdue), applied to range E2:E10.
The Challenge
You need to update the Status column on your Samsung Galaxy Tab S9 while at a warehouse audit. You also need to sort by Amount descending, then filter for Overdue only — and save changes that survive closing the app.
Here’s what makes it tricky:
- Excel for Android doesn’t support all desktop features — like custom number formats inside tables, or dynamic array formulas spilled into adjacent cells.
- If you open the file via Google Drive instead of OneDrive, Excel won’t load the conditional formatting — and you’ll lose it permanently on save.
- Tap-and-hold to select a range? That selects one cell. To select A1:E10, you must tap A1, then drag the blue handle down-right. Miss the handle by 2mm, and you get A1:A2.
Most people assume “it’s Excel” — so they expect Ctrl+C/Ctrl+V. On Android, it’s long-press → Copy → Paste. And Alt key shortcuts? They don’t exist… unless you connect a Bluetooth keyboard.
Walking Through It
You’re using Excel for Android v24.1200.17000, installed from Google Play, signed in with your Microsoft account. Your tablet is connected to OneDrive. You opened the file directly from the OneDrive app — not email, not Downloads folder.
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | Tap cell E5 (TerraLink’s status). Tap again to activate edit mode. | Keyboard appears. Text “Overdue” is selected. | — |
| 2 | Type “Paid”, then tap the green checkmark in the formula bar. | E5 updates. Conditional formatting turns cell green — but only if you’re online and synced to OneDrive. | — |
| 3 | Tap the Sort icon (three horizontal lines + arrow) in top toolbar. Choose “Amount” → “Largest to Smallest”. | Rows reorder. V-784 (Acme Corp, $15,300) moves to row 2. Original row order is gone — but undo (tap ← arrow) restores it instantly. | Alt+H+S+O (with keyboard) |
| 4 | Tap Filter icon (funnel). Tap “Status” → uncheck “Paid” and “Pending”. Leave only “Overdue”. | Two rows remain visible: V-785 and V-788. Hidden rows stay intact — no data loss. | — |
Important: If you tap “Clear All Filters” after step 4, Excel for Android will reset the sort order — back to original. That’s counterintuitive. Desktop Excel preserves sort even after clearing filters. Android doesn’t.
The Result
After editing E5, sorting, and filtering, here’s what you see when you re-enable all rows and clear filters — with changes saved and synced:
| Vendor ID | Company Name | Invoice Date | Amount ($) | Status |
|---|---|---|---|---|
| V-784 | Acme Corp Supply Chain | 2024-04-07 | $15,300 | Paid |
| V-782 | Nexus Freight Ltd. | 2024-04-02 | $12,450 | Paid |
| V-786 | Summit Haulage Group | 2024-04-12 | $11,840 | Pending |
| V-790 | Aurora Freight Partners | 2024-04-20 | $10,500 | Paid |
| V-787 | Orion Transit Solutions | 2024-04-14 | $9,260 | Paid |
| V-783 | Blue Ridge Logistics | 2024-04-05 | $8,920 | Pending |
| V-789 | Veridian Load Services | 2024-04-18 | $7,430 | Pending |
| V-785 | TerraLink Distribution | 2024-04-10 | $6,710 | Paid |
| V-788 | Coastal Express Co. | 2024-04-16 | $13,090 | Overdue |
Note: V-785’s status is now “Paid”. Sorting held. Conditional formatting stayed intact — because you opened via OneDrive, not local storage or Google Drive.
What Could Go Wrong
Three mistakes I’ve seen in live demos — every time:
- You open the file from Downloads → Edit → Save → Close → Reopen → All formatting is gone.
Why? Excel for Android treats local files as “view-only” unless explicitly saved to cloud. Even if you tap “Save As”, it defaults to device storage — not OneDrive. Fix: Always use “Save a Copy” → OneDrive → overwrite original. - You copy-paste a formula from A1 into C10, and it shows “#REF!”.
Because Excel for Android doesn’t auto-adjust relative references during paste if the destination range isn’t selected first. Do this: Select C10:C15 *before* pasting. Then it works. - You type “=SUM(D2:D10)” in cell D11, hit Enter, and get 0 — not $105,400.
That’s because the cell is formatted as Text. Android doesn’t auto-detect formula entry like desktop does. Tap the cell → tap Format icon → Number → Number → Done. Then retype the formula.
Final action: Open Excel for Android right now. Go to File → Open → OneDrive → pick any .xlsx. Try this sequence: Tap A1 → tap the formula bar → type “=ROW()” → Enter. If it returns “1”, you’re good. If it returns “#NAME?”, your install is corrupted — uninstall, reboot, reinstall.
