You can look at David McRitchie's webpage discussing this

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

"SB" wrote:

I have 2 columns in alphabetical order. I need to be able to insert a line
into the 1st column and have the last line in this column wrap to the 2nd
column, thus keeping the spreadsheet to one page? I know this can be done, I
just can't remember how!