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

Insert And Delete Rows And Columns In Excel

Software Requirement

Prerequisite Knowledge

Open A New Excel

Add Data In Excel

Add Row In An Excel

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

Add Column In An Excel

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

Delete Row In An Excel

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

Delete Column In An Excel

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