Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to delete cells in Google Sheets.
How To Delete Cells In Google Sheets
Google Sheets is a powerful spreadsheet program that allows you to organize your data in a variety of ways. However, you may find yourself needing to delete cells, rows, or columns from your spreadsheets.
For example, you may have noticed a row or column that is a duplicate. Or you may no longer need a particular row or column in your dataset.
Users may also want to delete a range of cells. The difference between deleting and clearing cells is that the former option shifts cells around since new cells will fill up the empty space left by the deleted range.
In this guide, we will show you how to delete cells, rows, and columns in Google Sheets.
How To Remove Cells, Rows, and Columns In Google Sheets
Here’s how to remove cells, rows, and columns in Google Sheets.
Select the cells you want to delete.
In this example, we want to remove the cell range B5:B9 since they contain 0 as a value.
Right-click on the selection and hover over the Delete cells option. The user has the option to either shift cells left or to shift cells up.
If you choose to shift cells to the left, the empty space will be filled by cells to the right of the deleted cells.
If you choose to shift cells upward, the empty space will be filled by cells below the deleted cells.
Next, we’ll explain how to delete a row in Google Sheets.
First, click on a row header to select the entire row.
Right-click on the selection and click on the Delete row option.
After deleting the row, the selection should now have data from the row directly below it.
You may also delete a column in a similar fashion.
Click on a column header and right-click the selection to reveal the Delete column option.
You can also find the delete options in the Edit menu.
This guide should be everything you need to remove cells, columns, and rows in Google Sheets. You may make a copy of this example spreadsheet to test it out on your own.