Friday, January 06, 2006
The Excel AutoFormat feature applies attractive formatting to a table automatically. To use AutoFormat, follow these steps.
Move the cell pointer anywhere within a table that you want to format. (Excel determines the table's boundaries automatically.)
Choose Format, AutoFormat.
Excel responds by opening its AutoFormat dialog box.
Select one of the 17 AutoFormats from the list, and click OK.
Excel formats the table using the selected AutoFormat.
If you attempt to apply an AutoFormat in a cell where all the surrounding cells are blank, Excel displays an error message.
You can't define your own AutoFormats, but you can control the type of formatting that Excel applies. If you click the Options button in the AutoFormat dialog box, the dialog box expands to show six options.
Initially, the six check boxes are all selected, which means that Excel applies formatting from all six categories. To skip one or more categories, just deselect the appropriate check boxes by clicking them before you click OK.
Move the cell pointer anywhere within a table that you want to format. (Excel determines the table's boundaries automatically.)
Choose Format, AutoFormat.
Excel responds by opening its AutoFormat dialog box.
Select one of the 17 AutoFormats from the list, and click OK.
Excel formats the table using the selected AutoFormat.
If you attempt to apply an AutoFormat in a cell where all the surrounding cells are blank, Excel displays an error message.
You can't define your own AutoFormats, but you can control the type of formatting that Excel applies. If you click the Options button in the AutoFormat dialog box, the dialog box expands to show six options.
Initially, the six check boxes are all selected, which means that Excel applies formatting from all six categories. To skip one or more categories, just deselect the appropriate check boxes by clicking them before you click OK.
