You need to access and edit your Excel files from your phone or tablet. The Excel mobile app provides core spreadsheet functionality for iOS and Android devices. This article explains how to sync your workbooks across devices and use the editing tools on a smaller screen. You will learn to open, modify, and save files directly from your mobile device.
Key Takeaways: Using Excel on Mobile
- Sign in with a Microsoft account: Enables automatic syncing of files through OneDrive, SharePoint, or Dropbox.
- Open menu (three horizontal lines): Navigates between recent files, pinned workbooks, and connected cloud locations.
- Edit button (pencil icon): Switches the workbook from read-only view to full editing mode on your device.
Overview of the Excel Mobile App
The Excel app for iPhone and Android is a free download from the Apple App Store or Google Play Store. It allows you to view, create, and edit workbooks. Full editing requires a Microsoft 365 subscription, though basic viewing is free. The app is designed for touch, with a ribbon interface adapted for mobile screens. Your files stay in sync when you save them to a connected cloud service like OneDrive.
Before you start, ensure you have a Microsoft account. This account is necessary to sign in and access cloud storage. Install the latest version of the Excel app from your device’s official app store. A stable internet connection is recommended for signing in and syncing files initially, though you can edit offline later.
Steps to Set Up Sync and Edit Workbooks
Follow these steps to get your files on your phone and begin editing.
- Download and open the Excel app
Search for “Microsoft Excel” in your device’s app store. Download and install the official app. Tap the Excel icon on your home screen to launch it. - Sign in to your Microsoft account
Tap “Sign In” on the welcome screen. Enter the email and password for your Microsoft account. This account should be the same one you use for OneDrive or your Microsoft 365 subscription. - Connect your cloud storage
Tap the Open menu (three horizontal lines) in the top-left corner. Select “Open” and then tap “Add a Place”. Choose your storage service, such as OneDrive, SharePoint, or Dropbox, and sign in to link it. - Open a workbook for editing
In the Open menu, navigate to your connected cloud location. Tap on the workbook file you want to edit. Once it opens, tap the “Edit” button (shaped like a pencil) in the top-right corner to enter editing mode. - Make changes and save
Tap any cell to select it. Use the keyboard that appears to enter data. Format cells using the toolbar icons (A for font, B for bold). Changes are saved automatically to the cloud as you work. Tap the back arrow to close the file when finished.
Creating a New Workbook on Mobile
- Start a new file
From the app’s home screen, tap the “New” button (a plus + sign). Select a blank workbook or a template from the gallery. - Name and save the file
Immediately tap the default file name at the top of the screen. Enter a descriptive name for your workbook. The file will be saved automatically to your device’s default OneDrive folder.
Common Mistakes and Limitations to Avoid
Excel App Says “View Only”
This happens if you open a file directly from an email attachment or a local download without saving it to a synced cloud location first. To fix it, save a copy to your connected OneDrive. Tap the File icon (three dots) > Save a Copy > choose your OneDrive folder. Then open the file from that location.
Formatting or Formulas Look Different
The mobile app supports most common functions and formatting, but some advanced features like specific chart types or complex macros will not work. The file will display but you cannot edit those elements. For full fidelity, open the file on the desktop version of Excel.
Changes Are Not Syncing to Other Devices
Ensure your device has an active internet connection. Check that you are signed in with the same Microsoft account on all devices. Manually trigger a sync by pulling down on the file list in the Open menu. Also verify the file is saved in a synced folder like OneDrive, not just locally on your phone.
Excel Mobile vs Desktop: Key Differences
| Item | Excel Mobile App | Excel Desktop (Windows/Mac) |
|---|---|---|
| Primary input method | Touch screen and on-screen keyboard | Mouse, keyboard, and touchpad |
| Advanced feature support | Limited; no VBA, Power Pivot, or Solver | Full support for all advanced tools and add-ins |
| File storage and sync | Requires cloud service (OneDrive) for full edit and sync | Files can be stored locally or on any network drive |
| Automated saving | Saves continuously to cloud as you edit | Requires manual save or AutoSave if file is in OneDrive/SharePoint |
| Cost for full editing | Requires Microsoft 365 subscription | Requires Microsoft 365 subscription or one-time purchase |
You can now open, edit, and sync your Excel workbooks directly from your iPhone or Android phone. Remember to use the Edit button to switch from viewing to making changes. For quicker access, pin frequently used workbooks from the Open menu. A concrete advanced tip is to use the “Tell Me” search bar in the mobile app ribbon to find commands like “Freeze Panes” without navigating menus.