Core Training for Microsoft Excel 2002

Setting Up a Workbook

Making Workbooks Easier to Work With

1 To rename the current worksheet, in the lower-left corner of the workbook window, double-click the Sheet2 sheet tab.
2 Type January, and press ENTER on your keyboard.
3 To move the January sheet tab to the left of the Sheet 1 tab, point to the January sheet tab, press the left mouse button down, drag it to the left of Sheet1, and release the mouse button.
4 To select columns A through M in order to change their width, click the column head at the top of column A and then click the right arrow on the horizontal scroll bar to scroll to the right.
5 Hold down the SHIFT key on your keyboard, click the column head for column M, and then release the SHIFT key.
6 Position the mouse pointer over the right edge of the heading for column L, hold down the left mouse button, drag the edge to the right until the ScreenTip above it says Width: 10.00 (75 pixels), and release the mouse button.
7 To increase the height of rows 3 through 35, click the row selector to the left of Row 3, click once beneath the scroll box in the vertical scroll bar, hold down the SHIFT key, click the row selector for row 35, and release the SHIFT key.
8 Position the mouse pointer over the bottom edge of the row selector for row 35, hold down the left mouse button, drag the edge down until the ScreenTip says Height: 25.50 (34 pixels), and release the mouse button.
9 To return to the upper-left corner of the page, hold down the CONTROL key while pressing the HOME key on your keyboard.
10 To merge and center the title across cells E2, F2, and G2, point to cell E2, press and hold down the left mouse button, drag to cell G2, and release the mouse button.
11 On the Formatting toolbar, click the Merge and Center button.
12 To insert a new, blank row below the title row, click cell A3.
13 Click the Insert menu, and then click Rows.
14 To insert a new column, labeled column A, to the left of the column previously labeled column A, click the Insert menu and then click Columns.
15 To temporarily hide rows 13 through 36 so that only data for the first week is visible, click the row selector for row 13 and then click three times below the scroll box in the vertical scroll bar.
16 Hold down the SHIFT key, click the row selector for row 36, and release the SHIFT key.
17 Click the Format menu, point to Row, and then click Hide.
18 To reveal the hidden rows again, click the Format menu, point to Row, and then click Unhide.

Making Data Easier to Read

1 To make the text in cell B34 wrap to fit within the original borders of the cell, click cell B34.
2 Click the Format menu, and click Cells.
3 In the Format Cells dialog box, click the Alignment tab.
4 In the Text control section, click the Wrap Text option to insert a check mark into its check box and then click OK.
5 To move to the upper-left corner of the worksheet, hold down the CONTROL key while pressing the HOME key on your keyboard.
6 To center the labels in cells B1 through E1 within each of those cells, point to cell B1, hold down the left mouse button, drag the pointer to cell E1, and release the mouse button.
7 On the Formatting toolbar, click the Center button.
8 To freeze row 1 and column A so that they stay in place when the remaining rows and columns scroll normally, click cell B2.
9 Click the Window menu, and then click Freeze Panes.
10 Notice the split bar that appears between rows 1 and 2 and between columns A and B. To see how the labels in row 1 and column A remain in place when you scroll, click once beneath the scroll box in the vertical scroll bar.
11 Click once to the right of the scroll box in the horizontal scroll bar.
12 To get rid of the split bars and allow the labels to scroll normally, click the Window menu and click Unfreeze Panes.
13 To freeze only the column labels in row 1 but not the row labels in column A, click cell A2, click the Window menu, and click Freeze Panes again.

Adding a Graphic to a Document

1 To begin inserting a graphic at the top of this worksheet, click cell A1, click the Insert menu, and click Rows to add some space for the graphic.
2 Click cell C1 to position the graphic.
3 To insert the graphic, click the Insert menu again, point to Picture, and click From File.
4 In the Insert Picture dialog box, double-click tgc_logo.gif.
5 To resize the graphic, click the Format menu and click Picture.
6 In the Format Picture dialog box, click the Size tab.
7 In the Scale section of the Size tab, notice that the Lock aspect ratio checkbox is selected, then double-click in the Height box to select the contents, type 50, and press ENTER.
8 The picture is resized, and the original aspect ratio is maintained. To allow more room for the graphic, position the arrow pointer between row numbers 1 and 2 at the far left side of the worksheet so that the pointer changes to a double-headed arrow.
9 Click and hold down the mouse button and drag down the pointer until it reaches with the border between row numbers 5 and 6, and then release the mouse button.
10 To save your changes, click the Save button on the Standard toolbar.

Managing Comments

1 To insert a comment in a cell, click cell B4 to select it.
2 On the Insert menu, click Comment.
3 A comment box appears. In the comment box, type Double-check this entry for January, then click cell B6.
4 A red comment flag appears in the upper right corner of cell B4. To view the comment, move and hold the mouse pointer over cell B4.
5 To edit the comment in cell B4, click cell B4, click the Insert menu, and click Edit Comment.
6 Double-click the word January to select it, type February, and then click cell B6.
7 To view the edited comment, again move and hold the mouse pointer over cell B4.
8 After you have double-checked the figure in cell B4, you can delete the comment. To delete the comment, click cell B4, click the Edit menu, point to Clear, and click Comments.