Step by step exercise. Moving on a worksheet


Objective.

 

To use different displacemnet methods within a worksheet, so we can go in a simple and quick way anywhere in the worksheet.

 

Step by step exercise.

 

1 Open Excel2003, if it isn't already opened, so you can check our instructions.

We'll start with the use of keys on the keyboard.

When we start we are in cell A1.

2 Press cursor key ARROW DOWN on the keyboard.

Notice that the active cell is now A2, so with the ARROW DOWN key you can go to the cell inmediately below in the same column.

3 Press cursor key ARROW UP on the keyboard.

Now the active cell will be again A1, because with the key ARROW UP we move to the cell above withim the same column.

4 Press cursor key ARROW TO RIGHT on the keyboard.

You will go to cell B1, that is, the cell right to the one you were within the same row.

5 Press cursor key ARROW TO LEFT on the keyboard.

You will return to A1, the cell left to the one you were in the same row

6 Press key PAGE DOWN on the keyboard

You will go to cell A23, so there has been a vertical movenment down in the sreen and we are in cell A23 or in A63 according to the number of rows that fit in the screen.

7 Press key PAGE UP on the keyboard.

You will go back to cell A1, so there has been a vertical movement up in the screen.

8 Click on cell D5.

It will automatically become the active cell.

9 Press key HOME on the keyboard.

Notice that with this key you go to cell D1, that is, the first cell in the row we are in.

10 Go to cell F9 just clicking on it.

11 Press key combination CTRL+HOME (Press and hold key CTRL on the keyboard, press key HOME, at the end you can let go both keys).

Notice that you have gone automatically to the first cell in the sheet, that is, A1.

12 Press key END and next cursor key ARROW DOWN.

The active cell becomes then the last one down within the same column, that is, A65536.

13 Press key END and then key ARROW TO THE RIGHT.

You go to the last cell to the right within the same row, that is, IV65536.

14 Press key END and next the key ARROW UP.

The active cell becomes IV1, that is, the last going up (the first) within the same column.

15 Press key END and next key ARROW TO THE LEFT.

You go back to cell A1, that is, the last cell to the left (the first) within the same row, as you can see, this method is the same as pressing the HOME key.

 

Now we are going to try using the scroll bar.

16 Click several times on the arrow pointing down  desplazamiento abajo of the vertical scroll bar so row 50 is displayed.

Notice that although there is a vertical movement in the screen, the active cell is still the same one and it is where we were before moving, that is, A1.

17 Click several times on the arrow pointing to the right desplazamiento derecha on the horizontal scroll bar so column Z is displayed.

18 To go to cell Z50, click on it. Now the active cell has changed.

19 Use the arrow pointing up desplazamiento arriba on the vertical scroll bar and the left pointing arrow  desplazamiento izquierda on the horizontal scroll bar, so you go to cell N50.

You may have notice that to move far within the sheet this method can be rather slow. To move faster you can use the scroll bar quicker. Just drag the scroll box within the scroll bar.

20 Drag down the scroll box in the vertical scroll bar (that is, press and hold the mouse button and drag with the mouse without letting go).

Notice that the movement is much faster.

21 Drag to the right the scroll box in the horizontal scroll bar.

Notice the result.

 

For more precise movements within a spreadsheet we will use the command Go to ...

22 Click on the menu Edit.

23 Click on the button so the menu drops down, if the option Go to...is not already available)

24 Click on the option Go to...

25 Type BT500 in the text box Reference.

26 Click on the button OK.

Notice that the active cell now is BT500.

27 Press key combination CTRL+HOME to go back to cell A1.



   
 
     
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.