USE AUTOFORMAT

Prev Show Me Step-By-Step Next

Get Ready
Select the cells you want to format. Click here: GO if you don't know how to do this. Use the Back button on your Browser to return here when you're through.

Begin
Display the Format menu and then click the word AutoFormat. In a few moments, the AutoFormat dialog box will display.
Select an AutoFormat from the list and then click the OK button.