Inserting Cell, Colum and Row in MS Excel

INSERTING CELLS, COLUMNS AND ROWS
To insert cells, columns and rows, follow the stepsgiven below:
1. Click on the Insert button on the Menu bar, then in the drop down menu click on cells.
2. You will get four options. Depending on your requirement, select the appropriate option.
a.  Shift cells right
b.  Shift cells down
c.  Entire row
d.  Entire column
a.  Shift cells right:This will add a blank cell to the left of the selected cell.
b.  Shift cells down:This will add a blank cell at the top of the selected cell.
c.  Entire row:  This will add a blank row above the selected row. After executing the command the worksheet will appear as:
d. Entire column:This will add a blank column to the left of the selected column.
e. To insert one or more columns
•  To insert one column: Follow the steps listed below.
 Select the cell to the left of which you want to insert the column
 Click on the Insert button in the Menu bar
 Select the Column option from the drop-down menu
•  To insert more than one column: Follow the steps listed below:
 Select the cell to the left of which you want to insert the columns
 Select the number of columns to be inserted
 Click on the Insert button in the Menu bar
 Select the Column option from the drop down menu.
f. To insert one or more rows
•  To insert one row: Follow the steps listed below:
 Select the cell above which you want to insert the row
 Click on the Insert button on the Menu bar
 Select the Row option from the dropdown menu
•  To insert more than one row: Follow the steps listed below:
 Select the cell above which you want to insert the rows
 Block/ Select the number of Rows to be inserted
 Click on the Insert button on the Menu bar
 Select the Row option from the drop down menu