Search
Clear search
Close search
Google apps
Main menu

Edit spreadsheets on Android

You can edit spreadsheets with the Sheets app.

Edit a spreadsheet

  1. Open the Google Sheets app .
  2. Tap the spreadsheet you want to edit.
  3. Double-tap the place in your spreadsheet you want to edit.
  4. Begin editing.

Note: If you're editing Microsoft Excel® files, you may see other editing options that aren't described below.

Editing options

Some editing options are only available on the most recent version of the Google Sheets app for Android or if you have "edit" access to the spreadsheet.

Format text in a spreadsheet

Bold, italicize, underline, and strikethrough text

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

Change font size, color, or style

  1. Open a spreadsheet.
  2. Tap a cell to select it. Move the blue markers to expand the number of cells that are selected.
  3. Tap Format Format.
  4. Change the font size, color, or style:
    • Size: Tap the arrows next to "Text size" to increase or decrease the size of your selected font.
    • Color: Tap Text color and choose a new color from the options that appear.
    • Style: Tap 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. Tap the spreadsheet to continue editing.

Change text alignment

  1. Open a spreadsheet.
  2. Tap a cell to select it. Move the blue markers to expand the number of cells that are selected.
  3. Tap Format Format.
  4. Choose from one of the following options to change how your text lines up vertically or horizontally:
    Icon Definition
    Left text align Left align (horizontal)
    Center text align Center align (horizontal)
    Right align 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. Tap the spreadsheet to continue editing.

Clear text formatting

  1. Open a spreadsheet on your Android device.
  2. Double-tap a word to select it. Move the blue markers to select more text.
  3. On the formatting menu, tap Clear formatting.
Format cells in a spreadsheet

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

  1. Open a spreadsheet.
  2. Tap a cell to select it. Move the blue markers to expand the number of cells that are selected.
  3. Tap Format Format.
  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 Tap Fill color and choose a color to fill the cells you’ve selected
    Borders Tap Borders and choose a border for your selected cells. You can also choose a style of border, and border color.
    Wrap text Tap from Off to On if you want all the text in your selected cells to be visible. Tap again to reverse the change.
    Merge cells Tap from Off to On to combine your selected cells into one cell. Tap again to reverse the change
    Number format Tap 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 Tap the “Up” and “Down” arrows next to “Decimal places” to add or remove decimal places from the numbers in your selected cells.
    Clear formatting Tap Clear formatting to remove all formatting from the selected cells
  6. Your selected cells will change when you choose an option. Tap the spreadsheet to continue editing.
Undo or redo an action

To undo an action in a spreadsheet in the Sheets app go to the top of the screen and tap Undo .

To redo an action, tap Redo .

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

Was this article helpful?
How can we improve it?