To apply an AutoFormat:
To apply an AutoFormat to your spreadsheet, first Select the text or data you want to format. Next, click AutoFormat... on the Format menu to open the AutoFormat dialog box. Scroll down the list of Formats to view the different layouts. When you find the combination of effects you like best, click OK. Your worksheet is automatically formatted.