Fill Cell

You can fill cells by using Edit, Fill and the selecting from the options available. Or you can use the REPT formula too.

Here is another way.

Right click a cell or range, select Format Cells, Number, Custom, then enter this

@*. (Please include the dot)

A line of dots will appear to the left of whatever is entered the cell. (Don't just use dots, use whatever you like)