Edit Google spreadsheets on Android
You can edit your Google spreadsheet within the Drive app whenever your phone or tablet has an Internet connection. Editing is available in all supported languages with left-to-right text. The Drive app also supports editing from a hardware keyboard attached to your mobile device. The latest version of the Drive app allows users to access, edit, and create spreadsheets in the new version of Google Sheets.
To begin editing, double-tap to select a cell, row or column to format, and begin entering text.
- Type text or numbers into your cells. Use the arrows next to your data entry window to move right and left within your row of cells, or touch Return on your keyboard to move down to the next cell in your column. Your changes will be saved regardless of when you click out of the cell you’re editing.
- Touch Done in the top left of your device screen when you’re done.
- The toolbar at the top of your screen provides formatting options (see “Cell formatting” below). You may need to scroll through this depending on the size of your device screen.
- Most functions available in Google spreadsheets on the web are supported in the app, with the exception of functions that depend on images (like =Sparkline() and =Image(), for example).
- For the time being, there is no way to select cells while typing a function. When working in the app, you’ll need to type in the names of the cells your function references.
- The =Sparkline() function can’t be displayed in the app because it relies on images, which the app doesn’t currently support. However, you can still enter the function into a cell, and it will show for your collaborators on the web.
Touch Done in the top left corner of your screen when you are done editing and want to return your spreadsheet to viewing mode.
- Touch a cell once to select it and begin adding text.
- Touch it again to bring up the menu of Cut, Copy, Paste, and Clear options.
- The formatting toolbar shows Bold, Italicize, Underline, and Strikethrough options for your text. You can also change a cell's font or background color. (You may need to scroll through to see all of it depending on the size of your device screen.)
- Touch a cell once to select it and drag the resize handle on the row or column if you would like to select multiple cells.
- Touch the Cells button that appears at the top of your screen.
- From the box that opens, touch the Numbers button to bring up the list of formatting options for numbers.
- Touch your desired number format, which will convert the numbers in your selected cell(s) to reflect the formatting option you have chosen.
Rows and columns
- Touch the header of a row or column to select and format the entire thing.
- Touch again to bring up the menu of Cut, Copy, Paste, Clear, Insert, and Delete options.
- Touch and drag the resize handle on a given row or column to resize.
- Drag the blue lines around it to select adjacent rows and columns.
- Sort your data by single-tapping a column header and selecting Sort on the far right of the resulting menu. The sort will apply to the entire sheet, as the app doesn’t support range sorting at the time.
- Note: The app doesn’t support column filtering at this time.
Freezing and unfreezing rows and columns is not supported in the app at the moment. However, rows and columns frozen on the web will be displayed when viewing in the app. To accommodate the size of your device screen, we limit the portion of your screen allotted to showing frozen rows and columns. As a result, you may need to scroll within the frozen section to see all frozen columns and rows.
- Touch the arrow next to a given sheet’s name to Delete, Duplicate, Rename, or Move the sheet to the right or left.
- Touch the + in the bottom right of your spreadsheet to add a new sheet.
- If you’ve accidentally deleted a sheet and want to restore it, you can do so by clicking Undo in the toolbar at the top of your screen.
Charts and images
Charts and images aren’t supported in the app at this time. However, you can modify the data displayed in a chart, and the changes in the chart will be displayed on the web for your collaborators.
The app will alert you if you are opening a sheet that contains charts and images that can’t be displayed within the app. However, if a collaborator adds a new chart or image while you are viewing the spreadsheet, you will not be notified of this until you close and reopen this spreadsheet in your app.