How to Delete Cells, Row & Column in Google Sheets

Author: Iqbal | Guide: Google Sheets |

Struggling with unnecessary rows and columns in your Google Sheet? Don't worry, the latest version of Google sheets now allows you to delete cells, rows, and columns in the app. In addition to that, you can also add rows and columns in your sheet! Let's begin our amazing leaning experience with this article.

How to insert and Delete Row and column in Google Sheet

Delete Cells, Rows, And Columns in 7 Steps

Step-1 Open Google Sheet For Desired Deletion: To get started with this technique, you first have to go to the Google sheet from which you want to delete cells, rows, or columns.

For that, you can either:

  • Open the Google sheet in your web browser,
  • Or, you can also download the free mobile application.

Do whatever suits your needs!

Image Title to delete cells row column step 1

Step-2 Select Your Cell: In this step, you need to perform the following two tasks:

  • one is to select the cell that you want to delete.
  • And then, right-click on the mouse.
Image Title to delete cells row column step 2

Step-3 To Delete Row, Click on 'Delete row': First, we will tell you how to delete the row in with the cell is present.

For doing that, you have to click on the option from the list that says 'Delete row'.

Image Title to delete cells row column step 3

Step-4 To Delete Column, Click On 'Delete column': Now, if instead of the row, you want to delete the column in which the selected cell is present. Then, you have to click on the option that says 'Delete column'.

It will delete the particular column.

Image Title to delete cells row column step 4

Step-5 Click on 'Delete Cells': We have learned how to delete rows and columns. Now, it's time to delete a cell.

For deleting just a single cell, you can sleep on the 'Delete Cells' option.

Image Title to delete cells row column step 5

Step-6 Click On 'Delete Cells and Shift Left': After clicking on 'Delete cells' in the previous step, you will get two options:

  • Delete cells and shift left
  • Delete cells and shift up

Here, click on the first option.

Image Title to delete cells row column step 6

Step-7 Or, Click On 'Delete Cells and Shift Up': After trying out the first option, click on the second option that says 'Delete cells and shift Up'.

Congrats! Now you have learned how to delete cells, rows, and columns in Google sheets.

Image Title to delete cells row column step 7

FAQ

How Can I Delete Rows and Columns in Excel Table?

If you have created a table in Microsoft Excel, and you want to delete a particular row and column from it. Then, the below steps are for you:

  • In your table, select a row or column that you want to delete.
  • Then, press the 'Backspace' key.
  • Or, you can also select the 'Table Tools Layout' tab from top.
  • Now, click on 'Delete'.
  • In Excel, select a row or column that you want to delete
  • Then, right-click.
  • Tap on the 'Delete' option.

How Can I Delete Thousands of Rows and Columns in Excel?

The best way to delete a large number of rows and columns from your MS Excel file is to use the keyboard shortcut key.

All you have to do is press 'Ctrl + –' on your keyboard. All the blank rows will now be removed.

How Can I Delete Blank Rows in Excel?

To Delete all the Blank Rows in your Excel file, do the following:

  • From your file, select the row to delete.
  • Click on its heading or you. Ab also selects a cell in the row.
  • Then, press 'Shift + spacebar'.
  • After that, you need to right-click the selected row heading.
  • Then, just Select the 'Delete' option from the drop-down menu that appears. That's it!

How Can I Delete Extra Columns in Excel That Never End?

In order to delete the never-ending columns from your Google sheet, you can follow the given procedure:

  • Go to your sheet and then, press 'Ctrl + Shift + Right Arrow' from your keyboard.
  • This will navigate you to the end of your datasheet.
  • You can now select the columns that you want to delete.
  • Then, just click right on your mouse.
  • Finally, tap on 'Delete' to delete them.

What is the Shortcut Key to Delete Multiple Cells in MS-Excel?

The keyboard shortcut key to delete multiple cells in MS- Excel program is 'Ctrl + Shift + Del'.

When you press this shortcut key, all the cells that you have selected will be deleted from your sheet. It does not matter whether the cells are blank or contain data. You can also sort and filter the data in Google sheets before deleting it.

 

 

 

 

 

Another Method

While making a spreadsheet in Google sheets, you might need to delete any Cell, Row, or column from the sheet as it might not be necessary or you do not need it anymore. It is easier to delete an entire row or column of a spreadsheet row than it is to delete or move the data stored in the cells of that row or column individually.  Like any spreadsheet program, you can delete a row or column in Google Sheets with a couple of clicks or taps.

This article will show you How to Delete Cells, Row & Column in Google sheets so that you can quickly format your spreadsheet without having to manually delete each item.

Delete Cells, Row & Column in 3 steps:

Step 1 - Open google sheets app: Before we go into the technicalities of how you can how to delete cells, row & column in Google Sheets, we need to have the application of google sheets installed on our device.

  • Look for the green-colored icon in the shape of an A4 size paper.
  • It has white outlined cells over it. If you cannot find it on your device, go to the play store.
  • Search for 'google sheets' in the search bar. Install the application to go further.

image titled Delete Cells, Row & Column step 1

Step 2 - Click on any row: Once you open the particular sheet in which you need to make changes, select the row (or column)  which you need to delete from the sheet. For selecting , right-click on the column or row which you want to select.

  • A drop down menu will come with many options to change the row (or column) selected , such as "Freeze", "Hide row", Resize row", "Delete", etc. You can tap on resize row and select fit to text.

image titled Delete Cells, Row & Column step 2

Step 3 - Click on delete to delete cell, row & column: Click on the Delete to delete the cell, row and column out of the drop-down menu. This will delete the selected row/column from the sheet.

  • Make sure you have checked the row/column/cell before deleting them.
  • If you are not sure and want to recheck the deleted row or column, you can always UNDO the "Delete" Command by either clicking on the UNDO button on the top left corner of the page or pressing the shortcut key Ctrl+Z on your keyboard.
  • This will undo the Delete command.

image titled Delete Cells, Row & Column step 3

Conclusion

Deleting cells, row and columns in google sheets is not at all that difficult. Rather it's a very simple 3 step process.

You can either delete the cells one by one. Or you can use the Delete Columns and Delete Rows feature to delete the entire row or column. The method of deleting cells one by one is very intuitive and takes a lot of time to. To use this method, you need to select the cell or cells at first. Then press the Delete key on your keyboard. On the other hand, using Delete Columns or Rows is more efficient. It is a better option as it enables you to quickly delete multiple rows or columns with a single action.

Was this article helpful ?

No