Inserting and Deleting

Inserting and Deleting

Microsoft Excel offers a convenient way for you to either insert or delete cell(s), column(s), row(s), or entire worksheet.

To insert a row(s) into a worksheet

·  Select the row you want to move down when the new row is inserted above it.

·  To select more than one row, drag the mouse pointer across the required row headings.

·  Right-click on the selected row(s) to display a pop-up menu.

·  Select Insert. Any existing data will move down to accommodate the new cells.

To insert column(s) into a worksheet

·  Select the column you want to move to the right when the new column is inserted.

·  To select more than one column, drag the mouse pointer across the required column headings.

·  Right-click on the selected column(s) to display a pop-up menu.

·  Select Insert. Any existing data will move down to accommodate the new cells.

To delete a row or column

·  Use the same techniques outlined above, but select the Delete command from the pop-up menu.

To insert cells or range of cells

·  Select the cell where you want to insert a new cell.

·  From the Insert menu, click Cells.

·  From the Insert dialog box, select one of the following options:

Entire column	Moves all cells in the column to the right and inserts a new column.
Entire row	Moves all cells in the row down and inserts a new row.
Shift cells down	Moves existing cells down and inserts one cell.
Shift cells right	Moves existing cells to the right and inserts one cell.

·  Click on the OK.

To delete cells or ranges of cells

·  Select the cell(s) you want to delete.

·  From the Edit menu, click Delete.

·  From the Delete dialog box displayed, select one of the options.

·  Click on the OK button.

To insert a worksheet

·  Click the sheet tab to select the worksheet where you want to insert a new one. The new worksheet will be inserted before this worksheet.

·  From the Insert menu, click Worksheet.

To delete a worksheet

·  Click on the sheet tab to select the worksheet you wish to delete.

·  From the Edit menu, click Delete Sheet.

·  Select OK to permanently delete the selected sheet.