excel2010 Drag cell settings

When using Excel, we often copy a lot of data, or drag the data to other cells, we usually copy and paste. In fact, in Excel2010 we can quickly populate cells with the ability to drag and drop cells.

Operation Steps

1, open Excel2010, select the upper left corner of the "file" function bar, and then click the "Options" function.

2, pop-up "Excel Options", click on the "Advanced" function bar, in the "Edit Options" Select the "Enable fill handle and cell drag and drop function" check box. Press the OK button.

3, enter any number of columns in the Excel formula bar, and then drag it.

4, so we have just entered a column of numbers dragged to the c6:c15.