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.
Read moreExcel Fill Handle
Fill Handle with Text in Excel
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.
Read moreExcel Fill Handle with Text and Numbers
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:
Read more