Excel Fill Handle

The fill handle is a convenient Excel tool that is used to fill data with a specific pattern. You can extend a series of numbers, dates and text combinations to desired number of cells.

To use fill handle bring the mouse cursor at right bottom corner of the cell it will change into a + sign. Now left click on it and drag it downward to the desired range of cells.

If you select one cell the value in the cell will be copied to other cells and if you choose multiple cells with specific pattern like difference between cells then the same pattern will be copied to other cells. See the image shown below.