How to Delete Unwanted Rows or Columns in the Existing Data

 

In this blog post, you will learn that how to delete unwanted rows and columns in the existing dataset.

Here in this tutorial, we are using the following dataset.

See the image below:-

Image-01

In the above image, we can see there are a row and column that has unwanted data.

And with the help of Excel tools, we want to remove or delete these rows and columns.

See, row (7) and column D contains unwanted data.

To delete an unwanted row or column, follow the below procedure.

First of all, find a cell in the unwanted column or row and make it an active cell.

Then Go to Home tab - -> find “Cells” group, at the extreme right side of the Excel window then click on Delete drop-down arrow and you will find the below options:-    

1. Delete Cells
2. Delete Sheet Rows
3. Delete Sheet Columns
4. Delete Sheet

Now select the required option from the above list and use it here.

If we want to delete an unwanted column, so we will use option ‘3 - Delete Sheet Columns’ and click on it.

See that the entire column has been deleted.

See the image below:-

Image - 02

The unwanted column is now deleted.

In the same way, we can delete the unwanted row within the dataset.

For deleting an unwanted row, first, make the row a current or active row by clicking on any of the cells in this row.

Then go to the Home tab and select Cells group and click drop down on the Delete button.

You will find the below option again:-

1. Delete Cells
2. Delete Sheet Rows
3. Delete Sheet Columns
4. Delete Sheet

Now we know that we want to delete unwanted rows this time.

So we will use option ‘2 - Delete Sheet Rows’ and click on it.

The unwanted row is deleted now, see the image below:-

Image - 03

See in the above image, the unwanted row is deleted now.

These are the easiest method to delete the unwanted rows or columns within the dataset.

Same way if you want to delete multiple unwanted rows or columns at one go. Then first select the unwanted rows or columns as many as you want to delete. And apply the same procedure to delete it by applying the method as we did earlier.

I hope you find this tutorial useful.

Please feel free to put your comments or suggestion in the box given below.

Thank you

Narendra Singh

Related Post

How to Change the Background Color in Excel VBA

Easiest Way to Copy and Paste Data in Excel VBA

What is Current Region Property in VBA

How to Change or Rename the Sheet Name in Excel VBA

How to Change Sheet Tab Color in Excel VBA

How to Change Font Color in Excel VBA