Edit spreadsheets on Android

You can edit your spreadsheets created in Google Sheets, as well as Excel® files, with the Sheets app for Android. Editing is possible whether or not your device has an Internet connection. Just make sure you’ve set up offline access for that spreadsheet.

To begin editing:

  1. Open the Sheets app for Android.
  2. Find the spreadsheet you want to edit.
  3. Double-tap the place in your spreadsheet where you’d like to make an edit.
  4. Begin making your edits.

Note that there may be additional features available when editing Excel® files in the Sheets app that aren’t covered in the information below.

Copy, cut & paste

Cut, copy, and paste text

To select the contents of a cell, touch the cell. Use the blue handles to expand your text selection to other cells.

Editing options will appear in a menu once you’ve selected text. Touch one to take action:

  • Cut
  • Copy
  • Paste

You can cut and paste, or copy and paste, text within or across spreadsheets in the Android app. But, text copied and pasted from one spreadsheet into another will be pasted without formatting.

Format text in a spreadsheet

Bold, italicize, underline, and strikethrough text

  1. Open the spreadsheet.
  2. Touch a cell to select it. Move the blue markers to expand the number of cells that are selected.
  3. Touch the Format icon .
  4. Choose from one of the following options:
    Icon Description
    Bold
    Italicize
    Underline
    Strikethrough
  5. The text in your selected cells will change when you choose an option. Touch the option again to remove the formatting.

Change font size, color, or style

  1. Open the spreadsheet.
  2. Touch a cell to select it. Move the blue markers to expand the number of cells that are selected.
  3. Touch the Format icon .
  4. Change the font size, color, or style:
    1. Size: Touch the arrows next to “Text size” to increase or decrease the size of your selected font.
    2. Color: Touch Text color and choose a new color from the options that appear.
    3. Style: Touch the current font being used and select a new font from the list
  5. The text in your selected cells will change when you choose an option. Touch back on the spreadsheet to continue editing.

Change text alignment

  1. Open the spreadsheet.
  2. Touch a cell to select it. Move the blue markers to expand the number of cells that are selected.
  3. Touch the Format icon .
  4. Choose from one of the following options to change how your text lines up vertically or horizontally:
    Icon Definition
    Left align (horizontal)
    Center align (horizontal)
    Right align (horizontal)
    Top align (vertical)
    Middle align (vertical)
    Bottom align (vertical)
  5. The text in your selected cells will change when you choose an option. Touch back on the spreadsheet to continue editing.
Format cells in a spreadsheet

There are a number of ways to format your cells and cell contents.

  1. Open the spreadsheet.
  2. Touch a cell to select it. Move the blue markers to expand the number of cells that are selected.
  3. Touch the Format icon .
  4. Go to the “Cell” section of the window that appears.
  5. Choose from one of the following options to change your cell formatting:
    Option Directions
    Fill color Touch Fill color and choose a color to fill the cells you’ve selected
    Borders Touch Borders and choose a border for your selected cells. You can also choose a style of border, and border color.
    Wrap text Touch from Off to On if you want all the text in your selected cells to be visible. Touch again to reverse the change.
    Merge cells Touch from Off to On to combine your selected cells into one cell. Touch again to reverse the change
    Number format Touch Number format and choose a type of formatting for the numbers within your selected cells. You can also choose from currency and date/time formatting.
    Decimal places Touch the “Up” and “Down” arrows next to “Decimal places” to add or remove decimal places from the numbers in your selected cells.
    Clear formatting (new Google Sheets only) Touch Clear formatting to remove all formatting from the selected cells
  6. Your selected cells will change when you choose an option. Touch back on the spreadsheet to continue editing.
Work with columns and rows

Insert a row or column

  1. Open the spreadsheet.
  2. Touch a cell next to the row or column you want to add.
  3. Touch the + button in the top-right.
  4. Choose Column left or Column right to add a column to the left or right of your selected cell. Choose Row above or Row below to add a row above or below the cell.

Delete a row or column

  1. Open the spreadsheet.
  2. Touch the header for the the row or column you want to delete.
  3. Touch the header again to pull up a menu.
  4. Choose Delete row or Delete column to remove the row or column from your spreadsheet.

Freeze panes, rows, or columns

You can freeze rows and columns of your spreadsheet so that you can continue seeing these cells as you’re moving around the spreadsheet.

  1. Open the spreadsheet.
  2. Touch the dropdown arrow next to the name of the sheet at the bottom of the screen.
  3. Touch the “up” and “down” arrows next to Freeze rows or Freeze columns to freeze a certain number of rows or columns in the sheet.

Hide a row or column

  1. Open the spreadsheet.
  2. Touch the header of the row or column you want to hide.
  3. Touch the header again and a menu will appear.
  4. Choose Hide row (or Hide column if you’ve selected a column).

Unhide a row or column

To see if a row or column is hidden in a spreadsheet, check if there are any skipped numbers or letters in the headers for the rows or columns. To unhide a row or column:

  1. Open the spreadsheet.
  2. Touch a row or column header on either side of the hidden row or column, then use the blue markers to highlight both of the rows or columns around the hidden item.
  3. Touch the selected headers again and a menu will appear.
  4. Choose Unhide.
Add formulas to a spreadsheet
  1. Open the spreadsheet.
  2. Touch the cell where you want to add the formula.
  3. Touch the Formula icon to the left of the text box at the bottom of the screen. If you want to type in the formula manually or the cell already has content in it, skip to step 7.
  4. Choose a type of function to choose from.
  5. Choose the function you want to use in your formula.
  6. Touch OK. A description of the function will show as you’re working on it to guide you through formula creation.
  7. To use the content of other cells in your formula equation, type the names of the cells into the formula. You can also touch a cell and drag the dots at the corners to select a range of cells.
  8. Choose from the symbols below the text box to add to the formula. For example, to subtract the contents of one cell from another, touch the - (minus) symbol.
  9. To finish the formula, touch the Checkmark .
Undo or redo an action

To undo an action in a spreadsheet in the Sheets app, simply touch the undo icon at the top of the screen.

To redo an action, touch the redo icon at the top.

Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.

How helpful is this article:

Feedback recorded. Thanks!
  • Not at all helpful
  • Not very helpful
  • Somewhat helpful
  • Very helpful
  • Extremely helpful