Articles → EXCEL → Insert And Delete Rows And Columns In Excel

Insert And Delete Rows And Columns In Excel

In this article I will explain how to insert and delete rows and columns in excel.

Software Requirement

Before you start reading this tutorial you should make sure that excel 2007 (or 2010) is installed on your machine.

Before you go ahead, it is required that you should know basics about excel.

First of all open a new excel and save it with the name ‘Insert_Delete_Rows_Columns_Demo.xlsx’ (you can give any name).

For this tutorial I am adding following data in excel file

You can insert row in an excel file by 2 methods

Method 1 -
1. Select a row
2. Right click on the row and click on ‘Insert’ as shown in figure below
Method 2 -
1. Select a row
2. Click on the ‘Insert Sheet Rows’ option on ‘Insert’ button

Click to Enlarge

Once you have inserted the row the excel will look like

Like rows, columns can be added by 2 methods

Method 1 -
1. Select a column
2. Right click on the column and click on ‘Insert’ as shown in figure below
Method 2 -
1. Select a column
2. Click on the ‘Insert Sheet Columns’ option on ‘Insert’ button

Click to Enlarge

Once you have inserted the column the excel will look like

To delete a row

Method 1
1. Select a row
2. Right click on the row and click on ‘Delete’ option
Method 2 -
1. Select a row
2. Click on the ‘Delete Sheet Rows’ option on ‘Delete’ button

Click to Enlarge

Once you have deleted the row the excel will look like

To delete a column

Method 1
1. Select a column
2. Right click on the column and click on ‘Delete’ option
Method 2 -
1. Select a column
2. Click on the ‘Delete Sheet Columns’ option on ‘Delete’ button

Click to Enlarge

Once you have deleted the column the excel will look like

Query/Feedback