Edit & format a spreadsheet


Want advanced Google Workspace features for your business?

Try Google Workspace today!

You can add data to a spreadsheet, then edit or format the cells and data.

Edit data in a cell

  1. Open a spreadsheet in the Google Sheets app .
  2. In your spreadsheet, double-tap the cell you want to edit.
  3. Enter your data.
  4. Optional:To format text, touch and hold the text, then choose an option.
    • To insert a new line, click Next> Insert line breakor press ⌘ + Enter.
  5. When done, tap Done.

Undo or redo an action

To undo or redo your last action while editing or formatting data, go to the top of the screen and tap:

  • Undo.
  • Redo.

Format one or more cells

  1. Open a spreadsheet in the Google Sheets app .
  2. Tap a cell, then drag the blue markers across nearby cells you want to select.
  3. Tap Format.
  4. In the "Text" tab, choose an option to format your text.
    • Bold
    • Italic
    • Underline
    • Strikethrough
    • Left text align
    • Center text align
    • Right text align
    • Top align (vertical)
    • Middle align (vertical)
    • Bottom align (vertical)
    • Text size, color, and style
    • Text Rotation
  5. In the "Cell" tab, choose an option to format your cell.
    • Cell fill color
    • Borders
      • Cell border
      • Border style
      • Border color
    • Wrap text
    • Merge cells
  6. Tap the sheet to save your changes.

Related links

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
4656992959497721298
true
Search Help Center
true
true
true
true
true
35
false
false
Design a Mobile Site
View Site in Mobile | Classic
Share by: