Microsoft Office Tutorials and References
In Depth Information
Navigating the spreadsheet
information logically. That said, these goals are not mutually exclusive, and I hope
all your documents are both logical and good-looking!
Navigating the spreadsheet
The best way to get to grips with the idea of the spreadsheet is to try it out, so let’s
begin our fi rst project.
Before you start to create your address book properly, I recommend that you
familiarise yourself with the basic controls for moving around a spreadsheet.
When you move your mouse pointer over the spreadsheet, it will turn into a plus
sign. If you click on a cell, you’ll see a heavy black box appear around it. This is
your cursor (see Figure 4.1), designed so that you can easily see which cell you’re
working on, and what it currently contains. Click on any cell and type ‘hello’ or
something else. Whatever you type will stay in the cell when you move your
cursor away. If you click on the same cell again and type something, you’ll overwrite
the old text.
You can also use your keyboard to move the cursor around. The most important
keys are:
Table 4.1 Keyboard shortcuts for Excel
Keys
How the cursor moves
Cursor keys (up, down, left,
right)
One cell in the direction of the
cursor key
Page Up
One screenful up
Page Down
One screenful down
Alt+Page Up
One screenful left
Alt+Page Down
One screenful right
CTRL+Home
To the top left corner
CTRL+End
To the end of your spreadsheet
(where the last row and column
used meet)
You can use the scroll wheel on your mouse to scroll up and down your
spreadsheet, or click and drag the scrollbars shown in Figure 4.1 to move around it.
 
Search JabSto ::




Custom Search