You can add data to a spreadsheet, then edit or format the cells and data.
Edit data in a cell
- Open a spreadsheet in Google Sheets.
- Click a cell that’s empty, or double-click a cell that isn’t empty.
- Start typing.
- Optional: To add another line within a cell, press ⌘ + Enter on a Mac or Ctrl + Enter on Windows.
- When you’re done, press Enter.
Format one or more cells
- Open a spreadsheet in Google Sheets.
- Click a cell, then drag your mouse across nearby cells you want to select, or hold ⌘ on a Mac or Ctrl on Windows and click another cell.
- To format text or numbers in a cell, use the options in the toolbar at the top.
Format your data
Align & resize objects
Add a theme
You can apply changes to the format of an entire spreadsheet with themes.
- Open a spreadsheet in Google Sheets.
- At the top, click Format
Theme.
- Choose an available theme or click Customize to create your own.
Notes:
- If you create a custom theme, the most recent version will be saved.
- Colors from your current theme are available in the text and fill color pickers.