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




Picture showing the sample excel file

Click to Enlarge


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
    3. Picture showing the Insert option in context menu for inserting new row in excel

      Click to Enlarge
  2. Method 2 -
    1. Select a row
    2. Click on the ‘Insert Sheet Rows’ option on ‘Insert’ button
Picture showing the Insert Sheet Row option for inserting new row in excel

Click to Enlarge



Picture showing the new row inserted into the excel file

Click to Enlarge


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
    3. Picture showing the Insert option in context menu for inserting new column in excel

      Click to Enlarge
  2. Method 2 -
    1. Select a column
    2. Click on the ‘Insert Sheet Columns’ option on ‘Insert’ button
Picture showing the Insert Sheet Column option for inserting new column in excel

Click to Enlarge



Picture showing the new column inserted into the excel file

Click to Enlarge


Delete Row In An Excel




  1. Method 1
    1. Select a row
    2. Right click on the row and click on ‘Delete’ option
    3. Picture showing the Delete option in context menu for deleting rows in excel

      Click to Enlarge
  2. Method 2 -
    1. Select a row
    2. Click on the ‘Delete Sheet Rows’ option on ‘Delete’ button
Picture showing the Delete Sheet Rows option for deleting rows in excel

Click to Enlarge



Picture showing the excel file after deleting the row

Click to Enlarge


Delete Column In An Excel




  1. Method 1
    1. Select a column
    2. Right click on the column and click on ‘Delete’ option
    3. Picture showing the Delete option in context menu for deleting columns in excel

      Click to Enlarge
  2. Method 2 -
    1. Select a column
    2. Click on the ‘Delete Sheet Columns’ option on ‘Delete’ button
Picture showing the Delete Sheet columns option for deleting columns in excel

Click to Enlarge



Picture showing the excel file after deleting the column

Click to Enlarge




Posted By  -  Karan Gupta
 
Posted On  -  Saturday, March 1, 2014

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250