Note:
Auto fill can be used to create a
range of sequences eg, :
Monday, Tuesday...
January, February...
8:30, 9:00, 9:30...
1st period, 2nd period, 3rd period...
P1, P2, P3...
Auto fill can be used to fill both Horizontal Vertical and sequences..
You can even create your own fill sequences See
Create a custom fill series in Excel help.