Datasheet

Adding and Editing Data in a Workbook

In Exercise 1.8, we’ll explore an alternative method for resizing the columns and rows pre-

cisely, using the menus.

5. Drag the right edge of the column until all of the text in cell D7 is visible. Then drag the

edge back to the left until the # signs reappear.

When you drag the column headers with the resizing pointer, you see a tooltip that tells

you the exact column width. The first number you see is the size in characters; the second

number, in parentheses, is the size in pixels.

6. Now, try double-clicking to let Excel automatically adjust it to the length of the value in D7.

7. Move to Sheet2 and double-click between the column headers for C and D to display the

full number in C5.

8. Change the number in cell E5 to 9501.977 and press Enter. Notice that the full number is

still displayed because it fits within the column.

9. Edit the number in E5 by adding a 9 at the end so that it now shows 9501.9779, and press

Enter. See that the number is shortened by one digit so that it fits within the column, and

is rounded to 9501.978.

10. Double-click between column headers E and F to adjust the column so the full number in

E5 is displayed.

11. Adjusting row height is similar to adjusting column width. Move your mouse pointer

over the gridline between the row headers on the left of your screen that say 3 and 4 until

you see the resizing pointer; then drag down to increase the height of row 3. The tooltip

that appears when you drag to adjust row heights shows the size in points first (1 point

equals 1/72 of an inch), followed by the size in pixels, in parentheses.

12. Double-click with the resizing pointer to make row 3 automatically adjust to the height of

the text in that row.

13. Leave the file open for the next exercise.

EXERCISE 1.8

Resizing Rows and Columns Using the Menus

1. Move to Sheet2 in Exercise 1-1.xls.

2. Change the column heading labels in cells B3 through E3 so the week numbers are

spelled out, making them Week One, Week Two, Week Three, and Week Four.

EXERCISE 1.7 (continued)

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