Auto Fill Handle In Excel. This feature is known as autofill. In the advanced category under editing options select or clear the enable fill handle and cell drag and drop check box.
For a series like 1 2 3 4 5. This feature is known as autofill. 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.
In the advanced category under editing options select or clear the enable fill handle and cell drag and drop check box.
The fill handle is the little green box at the lower right of a selected cell or selected range of cells. A basic level of knowledge about fill handle excel could save you tons of your productive time at your workplace. In the advanced category under editing options select or clear the enable fill handle and cell drag and drop check box. The fill handle in excel allows you to automatically fill in a list of data numbers or text in a row or column simply by dragging the handle.