Can you just make A3=A1 and copy down?

If formula is not an option, you can always copy A1:A2, then highlight
A3:A400 and paste.



Teric506 Wrote:
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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=469522