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


Objective.

 

Practice the insertion of rows, columns, cells, and sheets into 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 are missing two sales people, and so we will add them ahead of John Smith.

3 Select rows 7-8, which is where we want to add the new rows.

4 Select the Insert menu.

5 Select the Rows option.

All the rows beneath the new one will drop one position down.

We will now introduce the data of the new sales people.

6 In row 7, add the data corresponding to Mike Stark, and whose sales are: 9750, 12500, 15000 and 18000.

7 In row 8, add the data corresponding to Neve Deloix, and whose sales are: 11000, 13000, 12500 and 15000.

8 Save the changes you have made.

 

We are now going to add one row more but using a different method this time.

9 Situate yourself in any cell in row 10, like cell A10 for example.

10 Select the Insert menu.

11 Select the Cells... option. If this option is not found, situate yourself over the button so that the menu unfolds.

The Insert cells dialogue box will appear.

12 Activate the Entire row option.

13 Clic on OK.

botón pegar desplegadoThe botón pegar button will appear to us with which we can specify the type of copying we want to insert the row. When we clic on this button a box will appear where we can indicate whether the new row aquires the same format as the row above, below, or no format at all.

 

It is not obligatory to use this button.

 

Rows can also be added from the previous option, but by selecting rows.

14 Select row 10.

15 Select the Insert menu.

16 Select the Cells option.

As row was selected instead of cells, the row is automatically added.

17 In row 10, add the data corresponding to Anna Williams, and whose sales are: 10000, 12500, 13000 and 17200.

18 In row 11, add the data corresponding to Sean Jones, and whose sales are: 9250, 10000, 12000 and 13000.

19 Close the workbook, saving the changes.

 

 

20 Open the Precipitations workbook in the My documents folder of the hard drive.

We notice that we are missing a city before London.

21 Select column F, which is where we want to add the new column.

22 Select the Insert menu.

23 Select the Columns option.

botón pegar desplegadoAt the moment of inserting rows the button botón pegar appears, where we can select the format of the new column, although it is not obligatory to use it.

 

We will now introduce the data on the new city:

24 In column F, add the data corresponding to Sao Paulo, and who's precipitations are 13, 12, 18, 15, 9, 8, 2, 1, 5, 14, 18 and 20.

25 Save the changes.

 

We will now add a new column but will use another method.

26 Situate yourself over any cell in column C, like cell C2 for example.

27 Select the Insert menu.

28 Select the Cells... option.

The Insert dialogue box will appear.

29 Activate the Entire row option.

30 Click on OK.

 

Columns can also be added using the previous option, but selecting columns.

31 Select column D.

32 Select the Insert menu.

33 Select the Cells option.

As columns was selected and not cells, the column is automatically added.

 

We will now add a new sheet to the book.

34 Select the Insert menu.

35 Select the Worksheet option.

Observe how a new sheet has been created in front of the active one.

36 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.