and if they were numbers to be repeated
a1: 1
a2: 2
and you wanted to copy down 1,2, 1, 2, 1, 2
then you would select A1:A2, and hold the Ctrl key as you drag down.
if you wanted numbers to increment by 3
A1: 1
A2: 4
so you get 1,4, 7, 10, 13, 16
then simply select A1:A2 and drag the fill handle down
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm