Modifying an AutoFormat

graphics/microsoft24.gif

Excel AutoFormats give any worksheet a professional look, but you may need to modify an AutoFormat to better suit the needs of a particular project. For example, the AutoFormat you applied might be perfect except that the font used should be different ”to match the font in the rest of your report. You can control individual elements in an AutoFormat so that not all are applied to the current worksheet. These changes are temporary; you can't permanently alter an AutoFormat.

Modify an AutoFormat

graphics/one_icon.jpg

Select a cell or range whose AutoFormat you want to change, or skip this step if you want Excel to "guess" which cells to format.

graphics/tow_icon.jpg

Click the Format menu, and then click AutoFormat.

graphics/three_icon.jpg

Click the AutoFormat you want to modify.

graphics/foure_icon.jpg

Click Options.

graphics/five_icon.jpg

Click to select or clear one or more Formats To Apply check boxes to turn a feature on or off.

graphics/six_icon.jpg

Click OK.

graphics/05inf20.jpg

graphics/05inf21.jpg

Did You Know?

You can let Excel choose the range to format . If you don't select the cells you want to apply the AutoFormat to, Excel will guess which cells you want formatted.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

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