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:

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.

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

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