Excel2010 How to set a drag cell
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.