Highlight a range of blank cells, type some text (which will appear in the first cell), and press Ctrl-Enter; the text will fill in every cell.

Name:  Repeat text in multiple cells.jpg
Views: 84
Size:  14.1 KB