Auto Fill Handle In Excel. Select one or more cells you want to use as a basis for filling additional cells. With the help of the fill handle a small box at the lower right corner or the active cell you can copy a cell or automatically complete a series.
Click file options. Rest your cursor in the lower right corner so that it turns into a plus sign like this. If needed click auto fill options and choose the option you want.
Excel s fill handle is a multipurpose small black dot or square in the bottom right corner of the active cell that can save you time and effort when it is used to copy the contents of one or more cells to adjacent cells in a worksheet.
For a series like 1 2 3 4 5. Drag the fill handle down up or across the cells that you want to fill. For a series like 1 2 3 4 5. If needed click auto fill options and choose the option you want.