Chapter 7: Changing Document Appearance

Page 140	To change the default font settings
	On the Tools menu, click Options . Click the General tab. Click the Standard Font down arrow, and select the font to use. Click the Size down arrow, and select the size for the default font.
140	To change cell formatting
	Click the cell you want to change. On the Formatting toolbar, click the button corresponding to the formatting you want to apply.
140	To add cell borders
	On the Formatting toolbar, click the Borders button s down arrow and then, from the list that appears, click Draw Borders . Click the cell edge on which you want to draw a border. Drag the mouse pointer to draw a border around a group of cells .
140	To add cell shading
	Click the cell to be shaded. On the Formatting toolbar, click the Fill Color button. In the Fill Color color palette, click the desired square.
144	To change row or column alignment
	Click the header of the row or column you want to change. On the Formatting toolbar, click the button corresponding to the alignment you want to apply.
144	To apply an AutoFormat
	Select the cells to which you want to apply the AutoFormat . On the Format menu, click AutoFormat . Select the AutoFormat you want to apply, and then click OK .
146	To format a number
	Click the cell with the number to be formatted. On the Format menu, click Cells . If necessary, click the Number tab. In the Category list, click the general category for the formatting. In the Type list, click the specific format, and then click OK .
151	To create a conditional format
	Click the cell to be formatted. On the Format menu, click Conditional Formatting . In the second list box, click the down arrow and then click the operator to usein the test. Type the arguments to use in the condition. Click the Format button, and use the controls in the Format Cells dialog box to create a format for this condition. Click OK .
155	To add a header or a footer
	On the View menu, click Header and Footer . Click the Custom Header or Custom Footer button. Add text or images, click OK , then click OK again to close the Page Setup dialog box.