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
You must be logged in to post a comment.