Clear search
Close search
Google apps
Main menu

Edit and format a spreadsheet

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 Google Sheets.
  2. Click a cell that’s empty, or double-click a cell that isn’t empty.
  3. Start typing.
  4. Optional: To add another line within a cell, press ⌘ + Enter on a Mac or Ctrl + Enter on Windows.
  5. When you’re done, press Enter.

Format one or more cells

  1. Open a spreadsheet in Google Sheets.
  2. 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.
  3. To format text or numbers in a cell, use the options in the toolbar at the top.

Format your data

Here are some options for formatting your cells or text. You can find these options above the document.

  • Undo Undo
  • Redo Redo
  • Bold Bold
  • Italic Italic
  • Strikethrough Strikethrough
  • Change font or font size
  • Color text Change text color
  • Color fill Change cell fill color
    • Single color
    • Alternating colors
  • Cell border Change cell borders
    • Border color Change border color
    • Border thickness Change border style
  • Merge cells Merge cells
  • Change horizontal text alignment
  • Change vertical text alignment
  • Rotate text in a cell
  • Wrap text in a cell

To format part of the text or content in a cell, double-click the cell, select what you want to format, then select a formatting option.

Related links

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?
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.