There are some ideas here
http://www.mvps.org/dmcritchie/excel/snakecol.htm
or download ASAP utilities
http://www.asap-utilities.com/
and use format, paper saver
Barbara
"Lindsey" wrote in message
...
I have a list that is 10,000+ lines long. I would like to downsize it by
half
by adding another column. Is there an easier way besides all the cutting
and
pasting?