Check out this site for tips... it ain't cute (Excel doen't make this easy), but it should do the job for you...

http://www.mvps.org/dmcritchie/excel/snakecol.htm

HTH

Bruce