Hide

The fill handle with text

You can download here the worksheet from this video to practice it by yourself!

The fill handle feature lets you repeat patterns throughout Excel cells, and this includes text, not just numbers.

Placing text in any cell and then using your fill tool (the black square sign in the bottom right corner) will copy that text exactly throughout all of the cells you fill it to.

You can also fill multiple cells at a time, and the format will remain the same. For instance, if you put a word in one cell, then a different word in the cell below it, select both and use the fill handle with them, it will place the same 2-cell combination throughout your fill range.

In fact, it can copy any number of cells in this way and fill them wherever you’d like, both vertical and horizontal.