Auto Fill cells

Automatically fill cells with data that copies a cell, follows a series, formatting only or with data, or uses Flash fill.

1. Select one or more cells you want to use as a basis for filling additional cells.

2. Move the cursor to the bottom right corner of the selected cell, and drag the  cross vertically or horizontally to as many as cells as you need.  No Auto Fill or cross? See Turn Auto Fill on or off.

3. After you let go, select the  Auto Fill Options button that appears and choose which kind of fill you want.

Tip: For more fill types, try  Fill on the Home tab. For more info, see Using the Fill command.

Automatically fill cells with data that copies a cell, follows a series, formatting only or with data, or uses Flash fill.

1. Select one or more cells you want to use as a basis for filling additional cells.

2. Move the cursor to the bottom right corner of the selected cell, and drag the  cross vertically or horizontally to as many as cells as you need.  No Auto Fill or cross? See Turn Auto Fill on or off.

3. After you let go, select the  Auto Fill Options button that appears and choose which kind of fill you want.

Tip: For more fill types, try  Fill on the Home tab. For more info, see Using the Fill command.

Automatically fill cells with data that copies a cell, fills a series, or uses Flash fill.

1. Select one or more cells you want to use as a basis for filling additional cells.

2. Move the cursor to the bottom right corner of the selected cell, and drag the  cross vertically or horizontally to as many as cells as you need.