Edit rows, columns & cells in a spreadsheet

Edit rows, columns & cells in a spreadsheet

You can add, delete, freeze, move, or hide rows and columns in a spreadsheet in Google Sheets.

Add rows, columns, or cells

  1. On your spreadsheet, select a row, column, or cell.
  2. Right-click the row, column, or cell.
  3. From the menu that appears, select Insert rowInsert column, or Insert cells.
  1. On your spreadsheet, highlight the number of rows, columns, or cells you want to insert.
  2. Right-click the rows, columns, or cells.
  3. From the menu that appears, select Insert [Number] or Insert cells. For example, if you highlight 5 rows, right-click the row header, and select Insert 5 above or Insert 5 below.
To add 100+ rows to your spreadsheet:
  1. On your spreadsheet, scroll to the bottom.
  2. Next to "more rows at the bottom," enter the number of rows you’d like to add.
  3. Click Add.

Change or move rows or columns

  1. On your spreadsheet, select a row or column to resize. You can also highlight multiple rows, columns, or cells.
  2. Right-click the row number or column letter, then select Resize row or Resize column.
  3. In the window that appears, enter a new height or width.
  4. Click Ok.
You can also click and drag the edge of a row or column to resize it.
To keep some data in the same place and still see it when you scroll, you can freeze rows or columns.
  1. On your spreadsheet, select a row or column you want to freeze or unfreeze.
  2. At the top, click View and then Freeze.
  3. Select how many rows or columns to freeze.
To unfreeze, select a row or column and, at the top, click View and then Freeze and then No rows or No columns.

Move rows or columns

  1. On your spreadsheet, select the rows or columns to move.
  2. At the top, click Edit.
  3. Select the direction you want to move the row or column, like Move row up.
You can also click and drag a row or column to a new location.

Move cells

  1. Select the cells to move.
  2. Point your cursor to the top of the selected cells until a hand icon appears.
  3. Click and drag the cells to their new location.
  1. On your spreadsheet, select the rows, columns, or cells to merge.
  2. At the top, click Format and then Merge cells, then select how you want your cells to be merged.

Delete or hide rows, columns, or cells

  1. In your spreadsheet, right-click a row, column, or cell.
  2. From the menu that appears, choose Delete rowDelete column, or Delete cells.
  1. On your spreadsheet, click a row or column to highlight it. You can also select multiple rows or columns.
  2. Right-click and select Hide row or Hide column from the menu that appears. An arrow will appear over the hidden row or column.
To unhide a row or column, click the arrow around where the row number or column letter used to be.

Comments