Auto Fill Handle In Excel. Select one or more cells you want to use as a basis for filling additional cells. In the advanced category under editing options select or clear the enable fill handle and cell drag and drop check box.
Excel will fill the selected cells by either repeating the value in the first cell or by inserting a sequence from the. Rest your cursor in the lower right corner so that it turns into a plus sign like this. The excel fill handle is a very quick way to copy text items or a series of values in a range.
Select cell a1 and cell a2 and drag the fill handle down.
Rest your cursor in the lower right corner so that it turns into a plus sign like this. For a series like 1 2 3 4 5. Select cell a1 and cell a2 and drag the fill handle down. Rest your cursor in the lower right corner so that it turns into a plus sign like this.
