Unit 2. How to start working with Excel (I).


We are going to see how you can introduce and modify different types of data available in Excel, and how to manipulate the different movement techniques within a workbook in order to create worsheets.

 

Excel Concepts

 

You might not be clear about Excel basic concepts such as Workbook, Workshet, Cell, Active Cell, Row, Column,... so perhaps it is advisable to review them here .

 

Quick movement within a sheet

 

Only a small part of a sheet is visible in the document window. Your sheet will generally occupy a larger number of cells than those visible in the area of your screen and it can be necessary to move within the document quickly.

When there aren't any documents opened, the active keys to move on the sheet are:

MOVEMENT KEYBOARD
One cell down ARROW DOWN
one cell up ARROW UP
Right Cell RIGHT ARROW
Left Cell LEFT ARROW
Screen down PAGE DOWN
Screen Up PAGE UP
Cell A1 CTRL+HOME
First cell cell of active column END+ARROW UP
Last cell of active column END+ARROW DOWN
First cell active row END+LEFT ARROW or HOME
Last cell active row END+RIGHT ARROW

Another way of moving quicky on the sheet, once you are sure what cell you want to go to, is using the dialog box Go to shown on the right:

Type in the tex box Reference the cell you want to go to.

Then click on OK.

ir a

To have access to the dialog box Go to you can press the key F5, use the keyboard, the key combination Ctrl+G or you can also unfold the menu Edit and select the option Go to...

menú edición

You can always use the mouse, moving with the scrolling bars in order to display the cell you want to go to and click on it.

If you want to practice these operations you can do this Exercise of scrolling on a sheet

 



   

Pag. 2.1

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.