Datasheet

Navigating in Excel

FIGURE 1.3 The Name box displays the cell address of the active cell.

The lines you see defining the cells are called gridlines. They do not print by default, but are

intended more for clarity when you view the data onscreen.

When you click any cell, you see it is outlined in black, as shown in Figure 1.3. Clicking a

cell selects it and makes it the active cell, meaning this is the cell that will be affected by what-

ever you type or do.

Now that you’ve read about the basic elements of the Excel interface, it’s time to under-

stand how to navigate around Excel. It’s not as easy as some programs, so it definitely war-

rants a discussion.

Navigating in Excel

Your next goal is to learn how to move around to the various locations in the workbook and

various places on the worksheets. This section includes exercises that teach you the different

ways to move around in Excel.

Moving Around in Workbooks

To see all the data in your workbook and edit the data, you must know how to effectively nav-

igate to different worksheets within the workbook. Exercise 1.2 teaches you how to do this.

EXERCISE 1.2

Navigating in a Workbook

1. Open Excel and select File  Open.

2. Find the file named Exercise 1-1.xls that you extracted from the zipped file for this chapter.

3. On Sheet1, you can see the January sales for five stores. Click the Sheet2 sheet tab at the

bottom of the worksheet. This is the March sales sheet.

4002book.fm Page 9 Friday, March 24, 2006 11:36 PM