Enable Fill Handle in Microsoft Excel
- Open Microsoft Excel and then click on File -> Options.
- Click Advanced, and then under Editing options, select the Enable Fill handle and cell drag-and-drop check box show the fill handle.
- To avoid replacing existing data when you drag the fill handle, make sure that the Alert before overwriting cells check box is selected. If you don’t want to see a message about overwriting nonblank cells, you can clear this check box.
Use the fill handle to fill data
To quickly fill in several types of data series, you can select cells and drag the fill handle .
Categories: Excel Tips and Tricks