Search
Clear search
Close search
Google apps
Main menu

We've gotten reports about some users being signed out of their accounts unexpectedly. We're investigating, but not to worry: there is no indication that this is connected to any phishing or account security threats. Please try to sign-in again at accounts.google.com and if you cannot remember your password, please use this link to recover your password. If you use 2-Step Verification, there may have been a delay in receiving your SMS code. Please try again or use backup codes.

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

One row, column, or cell
  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 row, Insert column, or Insert cells.
More than one row, column, or cell
  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

Change row height or column width
  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.

Freeze or unfreeze rows or columns

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, columns, or cells

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.
Merge rows or columns
  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

Delete rows, columns, or cells
  1. In your spreadsheet, right-click a row, column, or cell.
  2. From the menu that appears, choose Delete row, Delete column, or Delete cells.
Hide rows or columns
  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.

Related article

 

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?