Depending on what you're doing with the data, you may decide to keep the data in
MSWord--and not use excel for this.

It can sort the data.
You can insert and delete cells easily.
Doing arithmetic gets more difficult, though.

Unknown wrote:

On Wed, 05 Sep 2007 06:48:49 -0500, Dave Peterson
wrote:

,;To save paper?
,;
,;I like to copy the data into MSWord and use MSWord's builtin ability to do
,;column layout. With lots of data, I sometimes have to paste into Notepad
,;first--large tables cause me trouble in MSWord.

Ms Word did it nicely. Setup 11 columns in "Format". Then copied and
pasted from the single column in Excel. If Word gets indigestion with
too much data in one excel column I can just bite off what Word can
handle.

Many thanks.

<stuff snipped

--

Dave Peterson