Each blank Excel workbook contains three worksheets. You can add or delete as many worksheets as you need. Because a workbook consists of one or more worksheets, you need to move between the worksheets. Here's how:
Click the tab of the worksheet you want to move to. If the tab isn't visible, use the tab scroll buttons, shown in Figure 1.16, to bring the tab into view, and then click the tab.
When the worksheet you want is visible on the screen, you need to move around in it. It's important to remember that the view on the screen might represent only a small portion of the total worksheet. After all, a worksheet can consist of more than one million cells. Even the biggest computer monitor can't display the entire sheet so that it is legible.
You move around your Excel worksheet with the mouse or the keyboard. To move from cell to cell, click the cell you want to move to. Notice that a dark border, called a selector, surrounds a selected cell. If the cell you want to move to isn't visible, use the scrollbars to move around the sheet.
If you're using an IntelliMouse, you can scroll around worksheets using the center wheel button. Hold down the wheel button and drag to quickly move through the worksheet.
If you're entering a lot of numbers or text from the keyboard, it's easier sometimes to move around a worksheet with the keyboard. That way, you can keep your hands on the keyboard and not have to jump on and off the mouse.
Table 1.3 shows the keystrokes you use to move around in a worksheet.
Press These Keys
To Move To
One cell down or to the next cell in sequence
One cell to the left
One cell up
Up Arrow, Down Arrow, Right Arrow, Left Arrow
One cell in the direction of the arrow
Ctrl+Right Arrow or Ctrl+Left Arrow
To the right or left end of a row that contains data
Ctrl+Up Arrow or Ctrl+Down Arrow
To the top or bottom of a column that contains data
To the first cell in the row
To the first cell in the worksheet
To the lower-right cell in the worksheet
Up one screen
Down one screen
Left one screen
Right one screen
To previous sheet
To Next sheet
F5 or Ctrl+G
Opens the Go To dialog box