Step by step exercise. Cell selection.


Objective.

 

Practice the different Excel2003 selection methods.

 

Step by step exercise.

 

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

Lets suppose that we want to select cell D6:

2 Click on cell D6 and a box will appear around it, indicating to us that it has been selected.

We are now going to perform a selection to include cells A1, A2, A3, A4, A5, A6, B1, B2... B6:

3 Situate yourself over cell A1 and clic, while maintaining the button depressed drag to cell B6 where you can release the mouse button.

On performing a new function it will have eliminated the previous one.

Observe how all the cells apart from the active one have changed colour, but are all selected.

If we want to add another cell or range to our selection:

4 Press the CTRL key, and maintaining it depressed click on cell D6.

Observe how the previous selection has not been eliminated.

5 Pressing the CTRL tab, add the E1:E5 range.

6 Click on cell A1 so that only it is selected.

If we want to select the entire column B:

7 Situate yourself over the column B identifier at the top of the calculation sheet, and click.

We can also select various adjacent columns, eg from column C to column E:

8 Situate yourself over the column C identifier, click and maintain the mouse, and drag to colum E.

Various non-adjacent columns can also be selected, eg from column A to column D:

9 Select column A .

10 Maintaining the CTRL tab depressed, click on the column D identifier.

We do the same with rows.

We are going to select row 2:

11 Click on the row 2 identifier in order to select the entire row.

We are going to select from row 4 to row 7 (adjacent rows):

12 Situate yourself over the row 4 identifier, click and maintain on the mouse, and drag to row 7.

We are now going to select rows 1 to 5 (non-adjacent rows).

13 Select row 1.

14 Maintaining the CTRL tab depressed, click on the row 5 identifier.

If we want to select an entire sheet:

15 Click on the upper left button of the sheet, situated between column A and row 1.

On occasions the selection that we might want to make might be too big and not all the cells will fit on the screen, eg from cell A1 to cell L40.

16 Try situating yourself in cell A1 and whilst maintaining the button depressed, dragging the mouse till cell L40.

When they extend out of the screen, the selection is made very quickly and it is possible that we might miss out on parts of the selection. To avoid this problem follow the next steps:

17 Select cell A1.

We will now enlarge the range until cell L40 :

18 Move yourself around the screen using the scroll bars until you can see the cell that will finish our selection, in our case L40.

Note that you do not need to click on any cell to perform step 18.

19 Press the SHIFT key, and maintaining it depressed, click on cell L40.

Observe the result of the operation.

This method can also serve to reduce the selection, eg if our selection should have been until K38 instead of L40:

19 Press the SHIFT key, and maintaining it depressed, click on cell K38.

Observe the result of the operation.

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