Welcome to Lesson 2 of the Intermediate Microsoft Excel Tutorial. In this lesson we will cover autoformatting. I hope you enjoy the lesson.

AutoFormatting

Step 1: About Autoformat
Excel provides several sample table formats that you can apply to your worksheet to make it more readable.

Step 2: Select items

Select the range, rows, or columns that you want to apply the autoformat to.

Step 3: Autoformat

Select Format, Autoformat

Step 4: Select Format

Click on the format style that you want

Step 5: Done

Your formatting style will be applied to the selected cells.