Explain the procedure to add and remove columns and Rows? (Excel-2007)

Q. Explain the procedure to add and remove columns and Rows?

Ans. When working with worksheets, you will often need to make changes to the original worksheets, such as deleting old information or adding new information. To make this task easier, you can add new rows and columns or delete existing rows and columns.

Adding Rows

1.     Select a cell below where you want to add a new row

2.    From the Ribbon, select the Home command tab

3.    In the Cells group, click the down pointing arrow on the INSERT button » select Insert Sheet Rows
A new row is added above the selected cell.

Adding Columns

1.     Select a cell to the right of where you want to add a new column

2.    From the Ribbon, select the Home command tab

3.    In the Cells group, click the down pointing arrow on the INSERT button » select Insert Sheet Columns
A new column is added left of the selected cell.

Deleting Rows

1.     To delete a single row, select any cell from the row to be deleted
To delete multiple non-contiguous rows, press [Ctrl] + select the cells from each row to be deleted

2.    From the Ribbon, select the Home command tab

3.    In the Cells group, click the down pointing arrow on the DELETE button » select Delete Sheet Rows
The row(s) are deleted.

Deleting Columns

1.     To delete a single column, select any cell from the column to be deleted
To delete multiple non-contiguous columns, press [Ctrl] + select the cells from each column to be deleted

2.    From the Ribbon, select the Home command tab

In the Cells group, click the arrow on the DELETE button » select Delete Sheet Columns
The column(s) are deleted.

Related Posts by Categories