Inserting and Deleting Columns and Rows

This section covers

  Inserting Columns

  Inserting Rows

  Deleting Columns and Rows

Inserting Columns

To insert a column, use one of the following methods:

 Method 1

• Step 1: Select a cell in the position where you want to insert a column. (To insert a column after Column B, click on any  cell in column C, say cell C5).

• Step 2: Choose Insert-->Columns.

To insert multiple columns,  select multiple cells in appropriate positions in Step 1. Selecting cells C5 to E5 in Step 1, will allow you to insert three columns between column B and column C.

Method 2

• Step 1: Select a column by clicking  on the heading of the column. 

• Step 2: Choose  Insert-->Columns.

You may select more than one column in Step 1 to insert multiple columns.

Inserting Rows 

To insert a row, use one of the following methods:

 Method 1

• Step 1: Select a cell in the position where you want to insert a row. (To insert a row after row 7, click on any cell in row 8, say cell C8).

• Step 2: Choose Insert-->Rows.

If you select multiple cells in Step 1, more than one row will get inserted. The positions of these rows will be determined by the cells you  choose in Step 1.

Method 2

• Step 1: Select a row by clicking  on the heading of the row. 

• Step 2: Choose  Insert-->Rows.

To insert multiple rows, select the appropriate rows in Step 1.

 

Example: If you select row 8 in Step 1, Excel will insert a row  after the seventh row. However, if  you select row 8 to  row 10 in Step 1,  Excel will insert three rows between the seventh and the eighth rows.

Deleting Columns and Rows

To delete Columns and Rows in an Excel worksheet,

• Select the  Columns or Rows  you want to delete.

• Chose Edit-->Delete