You can add data to a spreadsheet, then edit or format the cells and data.
Edit data in a cell
- Open a spreadsheet in the Google Sheets app.
- In your spreadsheet, double-tap the cell that you want to edit.
- Enter your data.
- Optional: To format text, touch and hold the text, then choose an option.
- To insert a new line, click Insert line break or press Ctrl + Enter.
- 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
- Open a spreadsheet in the Google Sheets app.
- Tap a cell, then drag the blue markers across nearby cells that you want to select.
- Tap Format
.
- In the 'Text' tab, choose an option to format your text.
Bold
Italic
Underline
Strikethrough
Left text align
Centre text align
Right text align
Top align (vertical)
Middle align (vertical)
Bottom align (vertical)
- Text size, colour and style
- Text rotation
- In the 'Cell' tab, choose an option to format your cell.
- Cell fill colour
- Alternating colours
- Borders
- Cell border
- Border style
- Border colour
- Wrap text
- Merge cells
- Tap the sheet to save your changes.