Core Training for Microsoft Excel 2002

Changing Document Appearance

Changing the Appearance of Data

1 To increase the font size of the text used as a title, click cell G2.
2 On the Formatting toolbar, click the Font Size down arrow and, on the list that appears, click 14.
3 To further emphasize the title by making this text bold, on the Formatting toolbar, click the Bold button.
4 To draw a border around this title, on the Formatting toolbar, click the down arrow at the right of the Borders button and then, on the list that appears, click Draw Borders.
5 Point to left edge of cell E2, hold down the left mouse button, drag to the right edge of cell I2, and release the mouse button.
6 On the Borders toolbar, click the Close button.
7 To give the title cell a yellow background, on the Formatting toolbar, click the down arrow to the right of the Fill Color button.
8 On the Fill Color palette that appears, click the yellow square (fourth row, third square from left).
9 To center the text for data labels within each cell in row 5, click the row head for row 5.
10 On the Formatting toolbar, click the Center button.

Applying an Existing Format to Data

1 To create a new style and apply it to the contents of cell C3, click cell C3.
2 Click the Format menu, and click Style.
3 In the Style dialog box, in the Style name text box, type Emphasis.
4 Click Modify.
5 In the Format Cells dialog box, on the Alignment tab, in the Horizontal box, click the down arrow and click Center.
6 To change the font style, click the Font tab.
7 In the Font style list, click Bold Italic.
8 To apply your changes to the new style, click OK.
9 To apply the Emphasis style to the text in cell C3, in the Style dialog box, click OK.
10 To copy the style applied in C3 to the contents of another cell, on the Standard toolbar, click the Format Painter button and click cell B5.
11 The format of cell C3 is applied to cell B5. To apply automatic formatting to the entire table, first click once below the scroll box on the vertical scroll bar, and then click once to the right of the scroll box on the horizontal scroll bar.
12 To select the entire group of cells from B5 to P38, hold down the SHIFT key and click cell P38.
13 To use AutoFormat to change the format of this group of cells, click the Format menu, and click AutoFormat.
14 In the AutoFormat dialog box, click once below the scroll box on the scroll bar, click the Colorful 2 format to select it, then click Options.
15 In the Formats to apply section that appears at the bottom of the AutoFormat dialog box, click to deselect the Number check box, the Alignment check box, and the Width/Height check box.
16 Click OK, and then click cell A1 to view the results.

Making Printouts Easier to Follow

1 To begin adding page header and footer information, click the View menu, then click Header and Footer.
2 In the Page Setup dialog box, click Custom Footer.
3 In the Footer dialog box,click anywhere in the Center section box, then click the Insert Picture button (second from the right).
4 In the Insert Picture dialog box, double-click the tgc_logo file.
5 Click the Format Picture button (last button on the right).
6 To maintain the aspect ratio of the image, in the Format Picture dialog box, click the Lock aspect ratio check box to select it.
7 In the Scale section, double-click inside the Height box to select the value displayed, type 50, click OK, and then click OK again.
8 The Page Setup dialog box displays a preview of the picture file you inserted. To add information to the page header, click Custom Header.
9 In the Header dialog box, since the cursor is already in the Left section box, click the Date button (fourth from the left).
10 Click anywhere in the Right section box, then click the Page Number button (second from the left), and click OK.
11 To preview the header and footer information you added, in the Page Setup dialog box, click Print Preview.
12 To close the Print Preview window and return to the worksheet, click Close.

Positioning Data on a Printout

1 To begin positioning worksheet data on a page, on the Standard toolbar, click the Print Preview button.
2 To view the margins on the page, in the Print Preview window, click Margins.
3 To adjust the bottom margin to fit the graphic within the footer, position the pointer above the second margin line from the bottom of the page so that the pointer becomes a double-headed arrow.
4 Click and hold down the left mouse button, drag the line up until it is positioned above the graphic, and release the mouse button.
5 Click Setup.
6 In the Page Setup dialog box, click the Page tab.
7 On the Page tab in the Orientation section, click Landscape.
8 In the Scaling section, click Fit to.
9 The default settings to fit the worksheet to one page wide by one page tall are fine. To finish up repositioning the worksheet, click the Margins tab.
10 On the Margins tab, in the Center on page section, click the Horizontally check box and then click the Vertically check box to select them.
11 To apply these settings and return to the Print Preview window, click OK.