"Shannan" wrote in message
...
Is there a way to have the text in cell B1 repeat every 10th cell down
that
column for the length of the spreadsheet?

Select B1 to B10 and simply pull the drag handle down Col B as far as you
want/need to go.

However, if you want the cells to update if the text in B1 changes, enter
=B1 in cell B11, select B11 to B20 and pull the drag handle down Col B as
far as you want/need to go.

Hope this helps?

V