The fill handle allows you to fill cells with data that originates from one or more source cells.
Let’s take a look.
The fill handle is a special box that appears in the lower right-hand corner of a selection.
The fill handle can fill cells in four directions: right and left; up, down.
It also works when more than one cell is selected.
The fill handle will also recognize and repeat certain patterns.
The fill handle will recognize the abbreviations as well.
The fill handle will also recognize and repeat numbers that appear with text.
It understands how to count using first, second, third and so forth.
It knows how to increment things like item numbers or product codes.
Finally, the fill handle will increment dates automatically in both directions.
