Step by step exercise. Copying cells.


Objective.

 

Practise the different ways of copying and duplicating cells within an Excel workbook.

 

Step by step exercise.

 

1 If Excel2003 is not open, open it in order to perform the exercise.

2 Start a new workbook

3 Introduce the value 34 into cell A1.

4 Introduce the value 20 into cell B1.

5 Introduce the formula =A1*2 into cell A2.

We are now going to copy cell A2 in cell B2. We will use the clipboard for this

6 Select cell A2.

7 Go to the Edit menu.

8 Select the Copy option.

The contents of cell A2 are now located in the clipboard.

9 Situate yourself in cell B2, as this is where we want to copy the previous cell to.

10 Go to the Edit menu.

11 Select the Paste option.

The contents of the cell found in the clipboard are now automatically placed where we are situated.

Observe how the contents of the copied cell in B2, will be =B1*2 .

As we have copied the cell one column to the right, the column reference within the formula will change one position, and instead of A it will put B, and as it is copied to the same row the reference to this will not vary. And so =B1*2 .The only thing that can change in the formula are the references to cells.

We can perform the same operation but using the buttons on the toolbar instead of the menu. To use this method we are going to copy cell A2 in cell D3, that is, 3 columns to the right and two rows down.

12 Select the cell to copy, that is, A2.

13 Click on the button on the toolbar.

14 Situate yourself where you want the cell to be copied , D3.

15 Click on the button on the toolbar.

Observe the result in cell D3 by situating ourselves in it and looking at the contents in the formula bar. As we copied the formula 3 columns to the right, in the formula the value of the column will increase by 3, and instead of A it will put D, and the row value will increase by 1 for copying the formula 1 row down, and so the resulting formula in cell D3 will be =D2*2 .

We are now going to copy the cells without using the clipboard. We will start by copying the contents of cell A1 in cell E6.

16 Select the cell to copy, that is, A1.

17 Situate the mouse pointer over any of the borders of the selection.

18 Release the CTRL tab.

The mouse pointer converts to .

19 Maintaining the CTRL released, click and maintain on the mouse whilst dragging toward the cell we want to copy to, E6, where we can release the mouse button and then the CTRL tab.

20 Observe the formula in cell E6.

We are now going to test the copying of adjacent cells, we will copy the formula in cell A2 in cells B2 , C2 , D2 y E2 .

21 Select the cell to copy, that is, A2.

22 Situate the mouse pointer over the bottom right corner where you see a black box (the fill controller). The mouse pointer converts to a black cross.

23 Click and maintain on the mouse while dragging to the right in such a way that all the cells that we want to copy the formula to remain marked, that is, until E2.

If we try to drag downward we see that we are not permitted to, as we are only permitted in the same column or in the same row.

24 Release the mouse button when all the cells you want to copy to are marked.

25 Observe the formulas in all the cells that we copied to.

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