Datasheet

10
Chapter 1

Navigating in Excel and Understanding the Interface
Moving Around in Worksheets
Moving from sheet to sheet is fairly straightforward; however, moving around within a work-
sheet is more complex because sheets can be very large and you can waste a lot of time scroll-
ing to find something. Once you’ve navigated to the sheet you want to work on, you can find
the particular cell that needs your attention in various ways, as demonstrated in Exercise 1.3.
4. Click Sheet3’s tab to see the February sales sheet.
5. Hold down the Ctrl key on your keyboard and tap the Page Up key. This is the keyboard
shortcut to move to the previous sheet, so this moves you back to Sheet2.
6. Press Ctrl+Page Down to move back to Sheet3.
7. When you have more sheets than can be displayed at the bottom of the workbook, you
use the tab scrolling buttons (First, Previous, Next, and Last) shown in Figure 1.2 to dis-
play the unseen sheets.
8. Leave this workbook open for the next exercise.
EXERCISE 1.3
Navigating in a Worksheet
1. Still inside the workbook named Exercise 1-1.xls, click the Sheet1 tab to get back to the
January sales sheet.
2. Use the vertical scrollbar on the right side of your screen to move the view of the sheet
up and down.
3. Use the horizontal scrollbar at the bottom of the screen to move the view left and right.
Scrollbars are necessary only when the data on your worksheet will not fit on one screen.
Since the data in this file does fit on one screen, using the scrollbars has a less obvious
effect.
4. Press Ctrl+Home to move to cell A1 on this sheet. This is the keyboard shortcut to move
to the first cell that contains data.
5. Press Ctrl+End to move to cell E8 on this sheet. This is the keyboard shortcut to move to
the last cell that contains data.
EXERCISE 1.2 (continued)
4002book.fm Page 10 Friday, March 24, 2006 11:36 PM