As I understand you would like to get list which repeats in a column?
as it would be from monday to sunday and then again?
so in this way you should create custom list
Tools | Options | Custom list
"Joel Reeves" <Joel wrote in message
...
I need a way for the columns in Excel to repeat. Let me explain. Pretend
the excel spreadsheet is a piece of paper. I would like to wrap that
piece
of paper around a cylinder so that if you turn it, the pattern repeats to
infinity. I hope I have made this clear enough. A reply with answers or
more questions would be greatly apreciated.