Formatting with AutoFormat

Excel's AutoFormat feature takes away some of the hard work involved in formatting a worksheet. AutoFormat provides you with 16 predesigned table formats that you can apply to a selected range of cells on a worksheet.

Instead of applying each format to your data, one at a time, you can apply a group of formats in one shot with one of Excel's predesigned formats. The AutoFormat command lets you select a format and transform your table with a couple of mouse clicks.

In the following steps, you get to try a predesigned format using the AutoFormat command.

  1. Select the cells that contain the data you want to format; in this case, select cells A3:M13.

  2. Choose Format, AutoFormat. The AutoFormat dialog box pops open , as shown in Figure 47.5. You see a palette of predesigned table format samples, each with a name .

    Figure 47.5. Predesigned table formats in the AutoFormat dialog box.


  3. Scroll through the table format samples. Stop at the List 2 sample.

  4. Click the List 2 sample table format.

  5. Click OK. Excel formats your table to make it look like the one in the sample you selected. It looks great!

  6. Click any cell to deselect the range. Figure 47.6 shows the table formatted with the List 2 AutoFormat. The green bars make the worksheet more attractive and readable.

    Figure 47.6. The worksheet formatted with the List 2 AutoFormat.


Sams Teach Yourself Office Productivity All in One
Sams Teach Yourself Office Productivity All in One (Sams Teach Yourself All in One)
ISBN: 0672325349
EAN: 2147483647
Year: 2003
Pages: 474
Authors: Greg Perry © 2008-2017.
If you may any questions please contact us: