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

Chapter 12. Making It Look Good > Automatic Formatting

Automatic Formatting

The fastest and easiest way to make a sheet presentable is to give it an AutoFormat. An AutoFormat contains a complete look for a range of cells 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 different look.

To AutoFormat a range of cells:

1.
Click any or all cells in the range you wish to format (Figure 12.29).

Figure 12.29. Click a cell in the range to be formatted.


2.
Choose Format > AutoFormat (Figure 12.30).

Figure 12.30. Choose Format > Autoformat.


3.
In the AutoFormat dialog box, select an AutoFormat from the list; a preview of that format appears to the right of the list (Figure 12.31). When you've made your final selection, click OK.

Figure 12.31. Choose an AutoFormat from the list. A preview appears to the right of it.


The range is formatted (Figure 12.32).

Figure 12.32. The AutoFormatted range.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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