Page 32 - Excel Data Analysis

02 537547 Ch01.qxd 3/4/03 11:45 AM Page 18

EXCEL DATA ANALYSIS

APPLY AUTOFORMAT TO A WORKSHEET

f you want to quickly change the appearance of your Excel replaces any previously applied custom formatting
worksheet, you can apply a predefined format. Excel with those that you select in the AutoFormat dialog box. For
I provides 15 different formats that create a table-like example, if you have previously selected Arial Black as the
layout for your data. The formats work best when your font for the entire worksheet, and you apply the Accounting
worksheet contains row and column headings and totals for 1 format, Excel changes the font to Arial, the default font
rows and columns. type for the Accounting 1 style.
You select a predefined format from the AutoFormat dialog The cells that you select before applying a format greatly
box. At the bottom of the dialog box, you find six different affect how Excel applies that format to your worksheet. If
format options: Number, Borders, Font, Alignment, Patterns, you select only one cell in a range of cells, Excel examines
and Width/Height. By default, Excel selects all six options the worksheet and applies the selected format to all
for you. You can adapt any one of the predefined tables by surrounding cells that contain values. As soon as Excel
deselecting options to achieve the effect that you want. For encounters a row or column of blank cells, it no longer
example, if you deselect the Font category, Excel does not applies the formatting. If you type values in the adjoining
make any font changes. As you select or deselect different cells after you apply the format, those cells automatically
formats, the AutoFormat dialog box reflects the changes receive the selected format. If you select a range of cells,
letting you view how the various options affect a particular Excel only applies the selected format to those cells.
table format before you select it.
APPLY AUTOFORMAT TO A WORKSHEET

⁄ Select the range of cells Note: See the section "Select a Range ■ The AutoFormat dialog box ‹ Click Options.
you want to format. of Cells" for more information. displays.
¤ Click Format ➪
AutoFormat.

18