How to insert and delete rows, columns, and cells

Spreadsheets organize and manipulate data. Whether you keep track of your small business expenses, catalog your Warhammer 40,000 collection, or compare the best Android tablets of 2022, spreadsheets get the job done. And if you’re an Android user, your spreadsheet of choice is likely Google Sheets.

But data changes. Sometimes you need to add data, and sometimes you have to delete data. Sometimes organizing your data means deleting a row of cells or inserting a column. These changes can be managed and accomplished with a few clicks or taps.

Add cells to your spreadsheet

Let’s say you’re a coin collector and organize your collection in Google Sheets. Only you forgot to add a column to track how much you paid. And you don’t want it at the end of your spreadsheet. Instead, you want it between two columns. In the browser, there are two ways to get this done.

Insert a column

1. Highlight the column (or an individual cell in the column) after which you’d like to insert the new data.

   

2. After highlighting the data, right-click on the cells. Or, hover over the column header and click the down-arrow icon.
3. From the menu, select Insert 1 column right.

   

The data to the right of the highlighted column shifts one cell to the right to make way for the new column. You can also select Insert 1 column left to shift the selected column and everything to the right of it, one cell to the right.

Insert a row

In this coin-collecting scenario, you might want to insert a row into your spreadsheet to make way for a new coin. The process for inserting rows is similar to inserting columns.

1. Highlight the row (or single cell in the row) before or after which you want to insert new cells.

   

2. Right-click the highlighted cells.
3. Select Insert 1 row above or Insert 1 row below, depending on your needs.

   

Insert a single cell

You may also want to insert a single cell, and the process is much the same, except you can only insert the new cell below or to the right of your selected cell.

1. Select the cell below or after which you want to insert an additional cell.

   

2. Right-click the selected cell.
3. Hover over Insert cells.
4. Select either Insert cells and shift right or Insert cells and shift down.

   

Don’t like right-clicking? After highlighting a row, column, or cell, click Insert from the top menu, then select what you need to do from the drop-down menu.

Insert multiple rows, columns, or cells

When using the web app, you can insert more than one row, column, or cell at a time. The steps are the same, except you highlight the number of rows, columns, or cells you want to insert. After that, choose the side of your selection you want to insert the new cells.

It’s also possible to insert rows by scrolling to the last row in the spreadsheet. Go to the bottom of the window to find a button and an input box to add an arbitrary number of rows to the bottom of the sheet. The default number of rows in a Google Sheet is 1,000, so this isn’t a feature you’re likely to use too often.

Insert rows and columns on the mobile app

If you’re on mobile, the process is largely the same:

1. Highlight the row, column, or cell before or after which you want to insert cells.
2. Tap the + button.
3. Select the side of the data you’d like the new cells inserted.

   

   

Delete rows, columns, and cells

Deleting rows, columns, and cells in the browser follows the same process as inserting:

1. Highlight the data you want to delete.
2. Right-click the highlighted data.
3. Select Delete row, Delete column, or Delete cell.

   

Likewise, you can use the menu in much the same way you insert cells.

1. Highlight the data you want to delete.
2. Click Edit from the top menu.
3. Hover over Delete.
4. Select Row, Column, or Cells.

   

The difference is that for deleting rows or columns, the existing cells automatically shift either up or left, respectively. When you delete cells, you can pick whether you want your data to be shifted up or left.

Delete data on the mobile app

If you’re on mobile, you can’t delete and shift a single cell or group of cells, but you can delete rows or columns.

1. Highlight the row or column to be deleted.
2. Tap anywhere in the selected area.
3. From the pop-up menu, select the three-dot overflow menu on the right.
4. Tap Delete.

   

   

Deleting a row shifts the lower cells up. Deleting a column shifts cells to the right of the deleted column to the left.

Clear data from cells

You may not want to shift your non-deleted cells. If you want to empty the cells of information without any shifting, there are a couple of ways to go about it. The fastest is to highlight the information you want to be cleared and press Delete on your keyboard. You can also accomplish it from a context menu using a right click.

1. Highlight the row or column to be cleared (this method can’t be used with cells).
2. Right-click the highlighted content.
3. Select Clear row or Clear column.

   

You can also accomplish the same thing by using the menu at the top of the screen.

1. Highlight the content you want to be cleared (row, column, or cells).
2. Click Edit from the top menu.
3. From the drop-down menu, hover over Delete.
4. Select Values.

   

Clear data from rows or columns on mobile

If you want to clear rows or columns without moving other cells on mobile, the process is similar to deleting and shifting.

1. Highlight the row or column to be cleared.
2. Tap the highlighted content.
3. From the pop-up menu, select Clear.

   

If you’re only clearing a cell, not an entire row or column, tap the three-dot overflow menu to access the Clear command.

Adding and deleting sheets

When the one-dimensional constraints of a row or column are too meager to manage your data, you might need to add a new sheet to your spreadsheet. If you haven’t worked with spreadsheets much, a sheet is the two-dimensional array of cells into which your data is placed. When creating a new Google Sheets document, it’s automatically created with one sheet. More can easily be added.

Adding and deleting sheets in Google Sheets using the browser

There are three ways to add a new sheet to your spreadsheet in the browser app.

1. From the ribbon menu, click Insert, then select Sheet from the drop-down menu.

   

2. Use the keyboard shortcut Shift + F11.
3. Click the + icon in the lower-left corner of the window.

   

You can keep track of your sheets at the bottom of the window. Each one is represented by a tab.

There are two ways to remove sheets from your spreadsheet:

• Click on the ▼ icon on the right of the sheet tab, then select Delete from the pop-up menu.
• Right-click on the sheet tab at the bottom of the window, then select Delete from the context menu.

  

You can delete multiple sheets at once by selecting more than one sheet (press Ctrl + Click to select multiple), then right-clicking and selecting Delete from the context menu.

Before Google Sheets removes the sheet, it asks you to confirm.

Adding and deleting sheets in Google Sheets using the mobile app

• To add a sheet using the mobile app, tap the + icon in the lower-right corner.

  

• To delete a sheet in the mobile app, tap the ▼ icon on the right of the sheet tab you wish to delete, then select Delete from the pop-up menu.

  

Put your data on lockdown

Congratulations! You are now a pro at cell and sheet manipulation in Google Sheets. When you don’t want anyone to edit or delete your numbers, or if you want to prevent yourself from accidentally deleting them, learn how to lock cells in Google Sheets.