You can use the fill handle. Highlight the numbers 1-8 then hold down CTRL
while dragging the fill handle.

Andrea Jones
http://www.stratatraining.co.uk
http://www.wrekinpublishing.com


"Ripper" wrote:

Thanks for the tips guys. I KNEW there had to be an easier way!
--
Thanks As Always
Rip


"dhstein" wrote:

Easier formula:
=IF(H17+18,1,H17+1)


"Ripper" wrote:

Is there a way to fill a repeating set of numbers. I have students listed by
their daily schedule. 1st period - 8th period. I want to create a period
column and have it fill in 1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8
all the way down the column to the last student. I tried fill series and
fill trend and even the fill handle to no avail.

Anyone know a trick other than copy and paste?
--
Thanks As Always
Rip