Add or motility columns & cells

Yous tin can add, alter, move, or delete your spreadsheet'south columns, row, or cells.

Add one row, cavalcade, or jail cell

  1. On your calculator, open up a spreadsheet in Google Sheets.
  2. Select a row, column, or cell.
  3. Right-click the row, column, or cell.
  4. From the carte that appears, select Insert 1 left, right, in a higher place or below.

Add more than one row, column, or prison cell

  1. On your computer, open up 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 menu that appears, select Insert [Number] or Insert cells.
    For example:
    1. Highlight 5 rows.
    2. Right-click anywhere on those rows.
    3. Select Insert 5 rows in a higher place 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 bottom," enter the number of rows you'd similar to add.
  3. Click Add.

Change row height or cavalcade 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 column letter.
  4. Click Resize row or Resize column. And then, choose an pick:
    • Enter a custom height or width
    • Fit to data
  5. Click OK.

You can also drag the border of a row or cavalcade to resize it or double-click the row or column edge to fit to data.

Motion rows, columns, or cells

Movement rows or columns

Add more than one row, column, or cell gif

  1. On your figurer, open up a spreadsheet in Google Sheets.
  2. Select the rows or columns to move.
  3. At the peak, click Edit.
  4. Select the direction you want to move the row or column, like Move row up.

You lot tin also drag a row or cavalcade to a new location.

Movement cells

  1. Select the cells to motion.
  2. Point your cursor to the elevation 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 function listing

Was this helpful?

How tin can we improve it?