Select the cells to which you want to apply an AutoFormat. Open the Format menu and select AutoFormat.
Scroll through the available formats on the AutoFormat dialog box.
Click the AutoFormat you want to apply to your data and click OK.
The AutoFormat is applied.
INTRODUCTION
Using all the formatting capabilities discussed to this point, you could format your worksheets in a very effective and professional manner but it might take a while to get good at it. In the meantime, you can use Excel's AutoFormat feature, which can format selected cells using predefined formats. This feature is a quick way to format large amounts of data and provides ideas on how to format data manually.
TIP
Modifying AutoFormats
If you find a format in the AutoFormat dialog box that almost but doesn't quite meet your requirements, you can apply that format but then make any necessary changes to it directly in the worksheet.