Search
Clear search
Close search
Google apps
Main menu

Edit rows and columns in a spreadsheet

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

Add rows or columns

Add rows or columns

  1. On your spreadsheet, select a row or column. You can also highlight multiple rows or columns.
  2. Right-click the row or column.
  3. From the menu that appears, select Insert.

Add multiple rows

To insert multiple rows or columns:

  1. On your spreadsheet, highlight the number of columns or rows you wish to insert.
  2. Right-click the column or row header.
  3. For the menu that appears, select Insert [Number]. For example, if you highlight 5 rows, right-click the row header, and select Insert 5 above or Insert 5 below.

To add a large number of rows (100+) to your spreadsheet:

  1. On your spreadsheet, scroll to the bottom.
  2. Enter the number of rows you'd like to add.
  3. Click Add.
Delete rows or columns
  1. On your spreadsheet, right-click a row or column.
  2. From the menu that appears, select Delete row or Delete column.
Change row height or column width
  1. On your spreadsheet, select a row or column to resize. You can also click and drag to highlight multiple rows or columns.
  2. Right-click the row number or column letter, then select Resize row or Resize column.

You can also click and drag the edge of a row or column to resize it.

Freeze or unfreeze rows or columns

To keep some data in the same place and still see them when you scroll, you can freeze rows or columns.

  1. On your spreadsheet, select a cell in a row or column you want to freeze.
  2. Click View and then Freeze.
  3. Select how many rows or columns to freeze.
  4. To unfreeze, select No rows or No columns.
Move rows, columns, or cells

Move rows or columns

  1. On your spreadsheet, select the rows or columns to move.
  2. On the menu, click Edit.
  3. Select the direction you want to move the row or column.

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. Drag the data to its new location. Release the mouse to drop it there.
Merge rows or columns
  1. On your spreadsheet, select the rows, columns, or cells to merge.
  2. In the menu, click Format and then Merge cells, then select how you want your cells to be merged.
Hide rows or columns
  1. On your spreadsheet, click the number of 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.
  3. Click the arrow to unhide the row or column.

 

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?