Chapter 7: Changing Document Appearance


Page 140

To change the default font settings

 
  1. On the Tools menu, click Options .

  2. Click the General tab.

  3. Click the Standard Font down arrow, and select the font to use.

  4. Click the Size down arrow, and select the size for the default font.

140

To change cell formatting

 
  1. Click the cell you want to change.

  2. On the Formatting toolbar, click the button corresponding to the formatting you want to apply.

140

To add cell borders

 
  1. On the Formatting toolbar, click the Borders button s down arrow and then, from the list that appears, click Draw Borders .

  2. Click the cell edge on which you want to draw a border.

  3. Drag the mouse pointer to draw a border around a group of cells .

140

To add cell shading

 
  1. Click the cell to be shaded.

  2. On the Formatting toolbar, click the Fill Color button.

  3. In the Fill Color color palette, click the desired square.

144

To change row or column alignment

 
  1. Click the header of the row or column you want to change.

  2. On the Formatting toolbar, click the button corresponding to the alignment you want to apply.

144

To apply an AutoFormat

 
  1. Select the cells to which you want to apply the AutoFormat .

  2. On the Format menu, click AutoFormat .

  3. Select the AutoFormat you want to apply, and then click OK .

146

To format a number

 
  1. Click the cell with the number to be formatted.

  2. On the Format menu, click Cells .

  3. If necessary, click the Number tab.

  4. In the Category list, click the general category for the formatting.

  5. In the Type list, click the specific format, and then click OK .

151

To create a conditional format

 
  1. Click the cell to be formatted.

  2. On the Format menu, click Conditional Formatting .

  3. In the second list box, click the down arrow and then click the operator to usein the test.

  4. Type the arguments to use in the condition.

  5. Click the Format button, and use the controls in the Format Cells dialog box to create a format for this condition.

  6. Click OK .

155

To add a header or a footer

 
  1. On the View menu, click Header and Footer .

  2. Click the Custom Header or Custom Footer button.

  3. Add text or images, click OK , then click OK again to close the Page Setup dialog box.




Microsoft Office 2003 Step by Step
MicrosoftВ® Office ExcelВ® 2003 Step by Step (Step By Step (Microsoft))
ISBN: 0735615187
EAN: 2147483647
Year: 2005
Pages: 350
Authors: Curtis Frye

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net