Datasheet

Chapter 1



Navigating in Excel and Understanding the Interface

If you accidentally drag to select multiple cells using the wrong mouse

pointer, cells may move or copy themselves. This is not what you want

to do, so use your Undo button if the incorrect action occurs.

Organizing Worksheets

You may have noticed that the worksheets in Exercise 1-1.xls are not in the correct order and

that the sheet tab names are not relevant to the data included in the sheets. The first sheet

shows sales for January, the second sheet shows the March data, and the third shows Febru-

ary’s information. The exercises in this section will show you how to perform all sorts of

worksheet tasks. You’ll learn to rename the sheets with names that reveal what is on the sheet.

You’ll also learn how to color-code sheet tabs, as well as how to move, copy, delete, insert, and

hide/unhide sheets.

EXERCISE 1.10

Hiding and Unhiding Rows and Columns

1. Move to Sheet1 in Exercise 1-1.xls and click any cell in column D.

2. From the Format menu, choose Column  Hide. Notice column D is now hidden and the

column headers show A, B, C, E.

3. If you immediately go back to the Format menu and choose Column  Unhide, the column

you just hid would return to view. But, instead of doing that, click any cell in column F and

choose Format  Column  Unhide. As you’ll see, nothing happens.

4. Click any cell in column C and, holding your mouse button down, drag to select the cell

to the right of it in column D so that both cells are selected. Be sure your mouse pointer

is a white plus sign while dragging, and not a black four-headed arrow or black plus sign

(these other pointers will be explained later).

5. With the two cells selected, choose Format  Column  Unhide, and column D will return

to view. To unhide a column, you must select cells on both sides of the hidden column

beforehand.

6. Once you have unhidden column D, click in any cell and hide that row by choosing For-

mat  Row  Hide. Notice the row is removed from view and the row header numbers

omit that number.

7. Select a cell in the row above the hidden row, and drag with the white plus sign to select

a cell in the row below the hidden row. Choose Format  Row  Unhide to bring the row

back into view.

8. Leave the file open for the next exercise.

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