Fill down problem. Does have other options?

If the first line set in EXCEL the formula, the following line project (with data) roughly the same formula, the drop-down fill.But I am too much data, the drop-down time-consuming, does have other options?

Double-click on the automatic selection the data can not, will not there other ways?

the cursor on the lower right corner of the cell, as when the double-cross into a solid, you can quickly fill.

to select the cell where the formula, mouse into the lower right corner of the cell, when the + appears, double click!

Menu – Data – List – Create a list will appear on the OK of the blue border *

Leave a Reply