Using AutoFormat

If you don't want to take the time to test different border types and shading styles, you can let Excel help you with the task of adding some emphasis and interest to the cells of your worksheet. You can take advantage of AutoFormat, which provides various predesigned table formats that you can apply to a worksheet.

To use predesigned formats, perform the following steps:

1. Select the cell (s) that contain the data you want to format. This could be the entire worksheet.

2. Select the Format menu, and then select AutoFormat . The AutoFormat dialog box appears (see Figure 10.3).

   Figure 10.3. Select a format from the AutoFormat dialog box.

   

3. Scroll through the list to view the various AutoFormat styles provided. When you find a format that you want to use, click it to select it.

4. To prevent AutoFormat from overwriting certain existing formatting (such as numbers , alignment, or fonts), click the Options button and deselect the appropriate check boxes.

5. Click OK and your worksheet is formatted.

Yuck! I Chose That? If you don't like what AutoFormat did to your work sheet, click the Undo button (or press Ctrl+Z ).