How Quickly Fill Series of Numbers Within Second (In Hindi)

How To Use AutoFill Options In Excel (In Hindi)

How to Protect or UnProtect Sheet in Excel (in Hindi)

How to Copy or Move Whole Sheets Into Another File

How to Generate Random Numbers Quickly in Excel

How to Apply Background Color In Excel

How to Hide or Unhide Rows and Columns in Excel (In Hindi)

How To Delete Unwanted Rows and Columns in Excel (In Hindi)

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

How to Insert Rows and Columns in Existing Data In Excel (In Hindi)

How to Insert Rows or Columns In Existing Data in Excel

In this blog post, you will learn about inserting rows or columns within the existing dataset.

Suppose we are working on a dataset and mistakenly we miss some data to enter. Now want to insert it within the existing dataset.

So for that, we will use the following ways to insert the data within the existing dataset. 

How to Insert Columns within the Existing Dataset

Here we are working on the dataset where we have a missing column between “Mar-21” and “May-21”.

See (Image-01) for example.

Now we need to insert one more column between Mar-21 and May-21, as Apr-21, to adjust our missing dataset.

Excel has a basic rule for inserting - new Rows, Columns, or Sheets always will be inserted just before the current or active cell or sheet.

So first of all, make our active cell where we want to insert a new column.

Here we want to insert a new column just before column May-21.

Image -01

This means we will put our cursor in just column “D” to insert a new column before it.

Put your cursor in the first cell of column “D”.

Go to the Home tab then the ‘Cells’ group at the extreme right side of the Ribbon.

Image-02

See the image above for help.

Click on the “Insert” drop-down, there is 4 option available here.

1. Insert Cells
2. Insert Sheet Rows
3. Insert Sheet Column
4. Insert Sheet

You have to choose from these options, as per your requirements.

For inserting a new column within the dataset, select one option from the above list.

So choose option “3 – Insert Sheet Columns”.

Click on this option, to insert a new column here before our active cell.

Here active cell column is D2, a new column will be inserted here, and the existing dataset pushed one column back.

See the image below:-

Image-03

A new column has been inserted.

And now, assign the name as Apr-21 to our newly inserted column and put our new data here.

See in the below dataset, our missing data is adjusted and looks like a complete dataset now.

Image -04

Insert New Rows within Existing Dataset.

In the same way, we can insert a new “Rows” within the existing dataset and adjust our missing dataset.

Sometimes we need to insert multiple rows and columns to adjust our missing data within the existing dataset.

Here we need to select multiple rows or columns, as per our requirement.

See the image below: -

Image -05

Follow the procedure below after selecting rows.

Go to the “Home” tab and go to the “Cells” group and click “Insert” drop-down and select one of the options from the below option:-

1. Insert Cells
2. Insert Sheet Rows    
3. Insert Sheet Column
4. Insert Sheet

Here we will select option “2 – Insert Sheet Rows” and Click on it.

New empty rows will be inserted, in place of selected rows.

See the image below:-

Image -06

Required blank rows inserted and here we can adjust our missing data.

So, here we learn to insert rows or columns within the existing dataset.

I hope you find this tutorial useful.

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

Thank you

Narendra Singh

Related Post

Easiest Way to Copy and Paste Data in Excel VBA

How to Change the Background Color in Excel VBA

How to use the MsgBox in Excel VBA

What is Current Region Property in VBA

How to Change or Rename the Sheet Name in Excel VBA

VBA With Statements In VBA (In Hindi)