Add or move columns & cells

Yous can add, alter, motility, or delete your spreadsheet's columns, row, or cells.

Add together one row, column, or cell

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row, column, or jail cell.
  3. Right-click the row, cavalcade, or cell.
  4. From the menu that appears, select Insert one left, right, to a higher place or below.

Add more than ane row, column, or cell

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Highlight the number of rows, columns, or cells you want to add. To highlight multiple items:
    • Mac:⌘ +click the rows or columns.
    • Windows:Ctrl +click the rows or columns
  3. Right-click the rows, columns, or cells.
  4. From the card that appears, select Insert [Number] or Insert cells.
    For case:
    1. Highlight v rows.
    2. Right-click anywhere on those rows.
    3. Select Insert 5 rows above or beneath.

To add 100+ rows to your spreadsheet:

  1. On your spreadsheet, curlicue to the lesser.
  2. Side by side to "more rows at the lesser," enter the number of rows you lot'd like to add together.
  3. Click Add.

Change row height or column width

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row or column to resize. To highlight multiple rows or columns:
    • Mac: ⌘ + click the rows or columns
    • Windows: Ctrl + click the rows or columns
  3. Right-click the row number or cavalcade letter.
  4. Click Resize row or Resize column. And then, cull an option:
    • Enter a custom height or width
    • Fit to data
  5. Click OK.

You tin can besides elevate the border of a row or column to resize information technology or double-click the row or column border to fit to data.

Move rows, columns, or cells

Motion rows or columns

Add more than one row, column, or cell gif

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the rows or columns to movement.
  3. At the tiptop, click Edit.
  4. Select the direction you desire to motion the row or column, similar Move row up.

You can also drag a row or column to a new location.

Motion cells

  1. Select the cells to move.
  2. Point your cursor to the top of the selected cells until a hand appears.
  3. Drag the cells to their new location.

Related articles

  • Freeze or merge rows
  • Protect a sheet or range
  • Google spreadsheets office list

Was this helpful?

How can we improve information technology?