I know this is probably a stupid question, but a have a column that I want to
read

1
2
1
2
1
2

for the entire column. Some sheets have more 400 lines so i don't want to
have to type each one in. Every time I try to drag it down it will not repeat
and I tried the repeat formula but it wants to ad decimals and changes the
number. any ideas on how to get it to do 1,2 all the way down? Thanks.

Teri