Auto fill month data

In this lesson, you are going to learn how to auto fill the word and cell style into your worksheet.

Auto fill the data

Click here for animated version

1. Type "Jan" to cell B1, click "Bold" button and "Center" button

autofill data

4. Point the mouse to bottom right of cell B2, click and drag to cell G2.

autofill data

5. Feb, Mar, Apr, May and Jun had been auto filled together with the cell style (Bold and center)

autofill data

<< Entering the word | List of Excel Tutorials | Enter and format number >>

Top