Excel Fill Handle

The fill handle is a convenient Excel tool that is used to fill data with specific patterns. You can extend the desired number of cells, a range of dates and text combinations. To use the fill handle, move the mouse cursor to the right lower corner of the cell, this will turn into a prompt.

Fill handle works in a similar way with texts. This helps the text to replicate the cells of the desired range. See the images shown below: The text is selected and then copied to other cells using the fill handle.

The Fill handle also works with both text and numbers. In this case, the text does not change but the number increases by one for each cell you select. View pictures: