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