office

Autofill in Excel is to move the cursor to the lower right corner of the locked cell, hold down the left mouse button when a solid cross appears, and drag the cell to complete autofill. The specific operation is as follows.

1. Open Microsoft. Office.Excel, and fill in 1 in cell A 1 and 2 in cell A2 respectively.

2. Select cells A 1 and A2.

3. Place the mouse at the solid black dot in the lower right corner of the selection until the mouse changes from a hollow cross to a solid cross, hold down the left mouse button and drag it to cell A 10.

4. Create an arithmetic series from 1 to 10.

5. Similarly, if the tolerance of arithmetic progression is 2, the sequence shown below will be obtained after automatic filling.