Step by step exercise. Delete Rows, Columns, Cells, and Sheets.


Objective.

 

Practice the deletion of rows, columns, cells, and sheets from an Excel workbook.

 

Step by step exercise.

 

1 If you do not have Excel open yet, open it in order to perform the exercise.

2 Open the Sales people workbook in the My documents folder of the hard drive.

 

We notice that we have 2 sales people too many.

3 Select rows 7-8, which are the rows to delete.

4 Select the Edit menu.

5 Select the Delete option.

All the rows beneath the new will move up a position.

 

We will now delete another row but will use another method:

6 Situate yourself over any cell in row 7, like cell C7 for example.

7 Select the Edit menu.

8 Select the Delete... option.

The Delete dialogue box will appear.

9 Activate the Entire row option.

10 Click on OK.

11 Close the worbook, saving the changes made.

 

12 Open the Precipiations workbook, found in the My documents folder of the hard drive.

We notice that we have one city too many.

13 Select column G, which is the column to delete.

14 Select the Edit menu.

15 Select the Delete option.

 

We will now delete columns C and D but will use a different method.

16 Select two cells from the columns to delete, like the range C4:D4 for example.

17 Select the Edit menu.

18 Select the Delete... option.

 

The Delete dialogue box will appear.

19 Activate the Entire column option.

20 Clic on OK.

21 Close the workbook without saving the changes.



 
 
Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.