To edit Google Sheets on your phone, install the free Google Sheets app from Google Play or the App Store, open your spreadsheet, and double-tap a cell to edit it (or tap the cell, then tap the formula bar). Type, then tap the check mark to save. Tap the Format button (A with lines) to change text, cell color, and alignment. The app for Android and iPhone also handles formulas, sorting, filtering, adding rows, sharing, and offline editing, although some advanced features need a computer.

Step 1: Get the App and Open a Sheet
- Install Google Sheets from Google Play (Android) or the App Store (iPhone and iPad).
- Sign in with your Google account.
- Tap a spreadsheet to open it, or tap + to create a new one. You can also open Sheets files from the Google Drive app.
Can I edit Excel files on my phone with Google Sheets?
Yes. The app opens .xlsx files and can edit them directly or convert them to Google Sheets.
Step 2: Edit Cells
- Edit a cell: double-tap it, or tap it and then tap the formula bar at the top.
- Save: tap the check mark, or tap another cell.
- Select a range: tap a cell, then drag the blue handles.
- Copy, cut, paste, or clear: tap and hold a cell to see the menu.
- Fill down: select the range, then drag the handle, or use Autofill in the menu (varies by version).
Step 3: Enter Formulas
- Double-tap the cell and type =.
- Type the function, such as
SUM(, then tap the cells you want or type the range, such asB2:B10. - Tap the check mark.
Tap fx (on Android) to browse functions. Sums and averages of a selected range also appear at the bottom of the screen.
Step 4: Format Your Data
Select cells and tap Format (A with lines):
- Text tab: bold, italic, font size, text color.
- Cell tab: fill color, borders, alignment, wrap text, number formats (currency, date, percent).
- Conditional formatting: tap ⋮ > Conditional formatting on Android (options vary on iPhone).
Step 5: Work With Rows, Columns, and Sheets
| Task | How |
|---|---|
| Insert or delete rows or columns | Tap a row number or column letter, then tap the arrow or ⋮ for Insert or Delete |
| Resize | Tap a header and drag its edge |
| Freeze a header row | Tap the row number > ⋮ > Freeze |
| Sort or filter | Tap a column header > Sort A-Z or Create a filter |
| Add a sheet tab | Tap + at the bottom |
- Tap the Share icon (person with +) to invite people as viewers, commenters, or editors.
- Tap and hold a cell and choose Comment to leave notes.
- Edits save automatically.
Edit Offline
- In the Sheets app, tap ⋮ next to the file.
- Turn on Available offline (or Make available offline).
- Edit without a connection. Changes sync when you’re back online.
What’s Easier on a Computer
Pivot tables, charts editing, Apps Script, add-ons, data validation rules, and complex conditional formatting are limited or missing in the mobile apps. On a phone, you can also open the full desktop site in a browser by requesting the desktop version, but it’s cramped.
You can also make a graph in Google Sheets from your data.
If the Sheet Won’t Edit or Sync
The file opens read-only
You have view or comment access. Ask the owner for edit access. Excel files may open in compatibility mode, so tap ⋮ > Save as Google Sheets for full editing.
Edits don’t appear on the computer
Check your connection and make sure you’re signed in to the same account. Pull down to refresh.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.