• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Formatting the Sheet > Choosing an AutoFormat

Choosing an AutoFormat

The fastest and easiest way to make a sheet presentable is to give it an AutoFormat. An AutoFormat supplies a complete look for a range of data by changing the font, text alignment, number formatting, borders, patterns, colors, column widths, and row heights. Excel provides a selection of AutoFormats, each with a unique look.

To choose an AutoFormat:

1.
Click any cell in the range to format (Figure 13.1).

Figure 13.1. Click a cell in the range that you want to format.


or

Select the range to format.

2.
From the Format menu, choose AutoFormat.

3.
In the AutoFormat dialog box, select an AutoFormat from the display (Figure 13.2).

Figure 13.2. Select a format in the AutoFormat dialog box.


4.
Click OK (Figure 13.3).

Figure 13.3. The AutoFormatted range.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint