Modifying Columns, Rows, and Cells

In Google Sheets modification of rows, cells, and columns can help personalize your file. Learn how here.

Inserting, deleting, and moving rows and columns

After you've been working with a spreadsheet for a while, you may find that you want to add new columns or rows, delete certain rows or columns, or even move them to a different location in the spreadsheet.

To insert a column:

  1. Right-click a column heading. A drop-down menu will appear. There are two options to add a column. Select Insert 1 left to add a column to the left of the current column, or select Insert 1 right to add a column to the right of the current column.
    Inserting a column
  2. The new column will be inserted into the spreadsheet.
    The newly inserted column

To insert a row:

  1. Right-click a row heading. A drop-down menu will appear. There are two options to add a row. Select Insert 1 above to add a row above the current row, or select Insert 1 below to add a column below the current row.
    Inserting a row
  2. The new row will be inserted into the spreadsheet.
    The newly inserted row

If you need to add more than one row at a time, you can scroll to the bottom of the spreadsheet and click the Add button. By default, this will add 1000 new rows to your spreadsheet, but you can also set the number of rows to add in the text box.

Adding multiple rows

To delete a row or column:

It's easy to delete any row or column you no longer need in your spreadsheet. In our example, we'll delete a row, but you can delete a column in the same way.

  1. Select the row you want to delete.
    Selecting a row to delete
  2. Right-click the row heading, then select Delete row from the drop-down menu.
    Selecting Delete row
  3. The rows below the deleted row will shift up to take its place. In our example, row 8 is now row 7.
    Rows will shift up when another row is deleted

There's a difference between deleting a row or column and simply clearing its contents. If you want to remove the content of a row or column without causing the others to shift, right-click a heading, then select Clear row or Clear column.

Clearing the contents of a row

To move a row or column:

Sometimes you may want to move a column or row to make it more accessible in your spreadsheet. In our example, we'll move a column, but you can move a row in the same way.

  1. Select the column you want to move, then hover the mouse over the column heading. The cursor will become a hand icon.
    Selecting a column to move
  2. Click and drag the column to its desired position. An outline of the column will appear.
    Moving a column
  3. Release the mouse when you are satisfied with the new location.
    The moved column