Here's our Microsoft Office Tip for.. November 16, 1998
Click Here to see a complete list of all of our previously released Tips!
Excel's AutoFormat
To format an entire list or other large range that has distinct elements - for example, column and row labels, summary totals, and detail data - you can apply a built-in table design, called an AutoFormat. The design uses distinctive formats for the various elements of the table.

To use AutoFormat, go to the menu and click Format, AutoFormat. When the AutoFormat window appears, click the Options button to select any or all styles to apply to the current selection.