I have an alphabetical list of songs in two colums-one for title and one for
artist. The list now is way too long (400 pages). Is there an easy way to
make this list in 4 colums and still keep it alphabetical?

--
Old Bob

If you're only using it as a list (no formulas), I'd copy and paste into
MSWord. Then you can use its formatting/sorting capability.



Old Bob wrote:
>
> I have an alphabetical list of songs in two colums-one for title and one for
> artist. The list now is way too long (400 pages). Is there an easy way to
> make this list in 4 colums and still keep it alphabetical?
>
> --
> Old Bob

--

Dave Peterson

Thanks Dave, I do not know much about word's sorting and formatting but I can
learn. I am a DJ and these are song books I print for the clients and 400
pages are way too much. Are there any simple instructions you can give me to
get me started after I get the data into word or do I just have to tough it
out through the work help? I would like a section for each letter and was
unaware word would sort.
--
Old Bob


"Dave Peterson" wrote:

> If you're only using it as a list (no formulas), I'd copy and paste into
> MSWord. Then you can use its formatting/sorting capability.
>
>
>
> Old Bob wrote:
> >
> > I have an alphabetical list of songs in two colums-one for title and one for
> > artist. The list now is way too long (400 pages). Is there an easy way to
> > make this list in 4 colums and still keep it alphabetical?
> >
> > --
> > Old Bob
>
> --
>
> Dave Peterson
>

65,536 (rows)* 400 (sheets) = 26,214,400(songs)
I find it hard to believe that anyone (DJ's included) would be cataloging
that many songs. What's the real skinny here ???


JR



"Old Bob" <OldBob@discussions.microsoft.com> wrote in message
news:C0F8FFD0-E1D5-404B-A49F-E44E96E42D12@microsoft.com...
>I have an alphabetical list of songs in two colums-one for title and one
>for
> artist. The list now is way too long (400 pages). Is there an easy way
> to
> make this list in 4 colums and still keep it alphabetical?
>
> --
> Old Bob

Copy the two columns in your excel workbook.
Paste into a new document in MSWord.
Select a cell in that MSWord table
Format|Columns and choose 4 (or what you want)

Depending on how things fit, you may have to change margins/font size/column
widths/space between columns and maybe orientation (landscape???).

Any time you want to insert a new row, just select an existing row, and
rightclick on the selection and choose Insert|Row.

You can be nice and insert it where it needs to be -- or you can sort the table
after all the inserting is done. That can be found under Table|sort.

(I used Office 2003 for my menus.)

===
In fact, if you like to do the typing in excel, you can keep it a nice 2 column
list, insert/sort as much as you want. Then just copy|paste and format in
MSWord before you print.





Old Bob wrote:
>
> Thanks Dave, I do not know much about word's sorting and formatting but I can
> learn. I am a DJ and these are song books I print for the clients and 400
> pages are way too much. Are there any simple instructions you can give me to
> get me started after I get the data into word or do I just have to tough it
> out through the work help? I would like a section for each letter and was
> unaware word would sort.
> --
> Old Bob
>
> "Dave Peterson" wrote:
>
> > If you're only using it as a list (no formulas), I'd copy and paste into
> > MSWord. Then you can use its formatting/sorting capability.
> >
> >
> >
> > Old Bob wrote:
> > >
> > > I have an alphabetical list of songs in two colums-one for title and one for
> > > artist. The list now is way too long (400 pages). Is there an easy way to
> > > make this list in 4 colums and still keep it alphabetical?
> > >
> > > --
> > > Old Bob
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

true true but I do have a 1 inch top and bottom margin and print in 14 font...
--
Old Bob


"JohnR" wrote:

> 65,536 (rows)* 400 (sheets) = 26,214,400(songs)
> I find it hard to believe that anyone (DJ's included) would be cataloging
> that many songs. What's the real skinny here ???
>
>
> JR
>
>
>
> "Old Bob" <OldBob@discussions.microsoft.com> wrote in message
> news:C0F8FFD0-E1D5-404B-A49F-E44E96E42D12@microsoft.com...
> >I have an alphabetical list of songs in two colums-one for title and one
> >for
> > artist. The list now is way too long (400 pages). Is there an easy way
> > to
> > make this list in 4 colums and still keep it alphabetical?
> >
> > --
> > Old Bob
>
>
>

Thanks again. I do prefer excel but I will start to train in word too and
the formatting of columns. Your getting me started is much appreciated.
--
Old Bob


"Dave Peterson" wrote:

> Copy the two columns in your excel workbook.
> Paste into a new document in MSWord.
> Select a cell in that MSWord table
> Format|Columns and choose 4 (or what you want)
>
> Depending on how things fit, you may have to change margins/font size/column
> widths/space between columns and maybe orientation (landscape???).
>
> Any time you want to insert a new row, just select an existing row, and
> rightclick on the selection and choose Insert|Row.
>
> You can be nice and insert it where it needs to be -- or you can sort the table
> after all the inserting is done. That can be found under Table|sort.
>
> (I used Office 2003 for my menus.)
>
> ===
> In fact, if you like to do the typing in excel, you can keep it a nice 2 column
> list, insert/sort as much as you want. Then just copy|paste and format in
> MSWord before you print.
>
>
>
>
>
> Old Bob wrote:
> >
> > Thanks Dave, I do not know much about word's sorting and formatting but I can
> > learn. I am a DJ and these are song books I print for the clients and 400
> > pages are way too much. Are there any simple instructions you can give me to
> > get me started after I get the data into word or do I just have to tough it
> > out through the work help? I would like a section for each letter and was
> > unaware word would sort.
> > --
> > Old Bob
> >
> > "Dave Peterson" wrote:
> >
> > > If you're only using it as a list (no formulas), I'd copy and paste into
> > > MSWord. Then you can use its formatting/sorting capability.
> > >
> > >
> > >
> > > Old Bob wrote:
> > > >
> > > > I have an alphabetical list of songs in two colums-one for title and one for
> > > > artist. The list now is way too long (400 pages). Is there an easy way to
> > > > make this list in 4 colums and still keep it alphabetical?
> > > >
> > > > --
> > > > Old Bob
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

I think "pages" refer to printed pages, and with, say, 50 to a page
that equates to 20,000 records - still a lot of songs !! <bg>

Pete

On Jul 7, 2:21*pm, "JohnR" <onejm.AT.comcast.net> wrote:
> 65,536 (rows)* 400 (sheets) = 26,214,400(songs)
> I find it hard to believe that anyone (DJ's included) would be cataloging
> that many songs. * What's the real skinny here ???
>
> JR
>

David McRitchie has a macro that will "snake" the columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Old Bob wrote:
>
> Thanks again. I do prefer excel but I will start to train in word too and
> the formatting of columns. Your getting me started is much appreciated.
> --
> Old Bob
>
> "Dave Peterson" wrote:
>
> > Copy the two columns in your excel workbook.
> > Paste into a new document in MSWord.
> > Select a cell in that MSWord table
> > Format|Columns and choose 4 (or what you want)
> >
> > Depending on how things fit, you may have to change margins/font size/column
> > widths/space between columns and maybe orientation (landscape???).
> >
> > Any time you want to insert a new row, just select an existing row, and
> > rightclick on the selection and choose Insert|Row.
> >
> > You can be nice and insert it where it needs to be -- or you can sort the table
> > after all the inserting is done. That can be found under Table|sort.
> >
> > (I used Office 2003 for my menus.)
> >
> > ===
> > In fact, if you like to do the typing in excel, you can keep it a nice 2 column
> > list, insert/sort as much as you want. Then just copy|paste and format in
> > MSWord before you print.
> >
> >
> >
> >
> >
> > Old Bob wrote:
> > >
> > > Thanks Dave, I do not know much about word's sorting and formatting but I can
> > > learn. I am a DJ and these are song books I print for the clients and 400
> > > pages are way too much. Are there any simple instructions you can give me to
> > > get me started after I get the data into word or do I just have to tough it
> > > out through the work help? I would like a section for each letter and was
> > > unaware word would sort.
> > > --
> > > Old Bob
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > If you're only using it as a list (no formulas), I'd copy and paste into
> > > > MSWord. Then you can use its formatting/sorting capability.
> > > >
> > > >
> > > >
> > > > Old Bob wrote:
> > > > >
> > > > > I have an alphabetical list of songs in two colums-one for title and one for
> > > > > artist. The list now is way too long (400 pages). Is there an easy way to
> > > > > make this list in 4 colums and still keep it alphabetical?
> > > > >
> > > > > --
> > > > > Old Bob
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Thanks--my reading and I seems to be cut out for me...
--
Old Bob


"Dave Peterson" wrote:

> David McRitchie has a macro that will "snake" the columns.
> http://www.mvps.org/dmcritchie/excel/snakecol.htm
>
> If you're new to macros, you may want to read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
> Old Bob wrote:
> >
> > Thanks again. I do prefer excel but I will start to train in word too and
> > the formatting of columns. Your getting me started is much appreciated.
> > --
> > Old Bob
> >
> > "Dave Peterson" wrote:
> >
> > > Copy the two columns in your excel workbook.
> > > Paste into a new document in MSWord.
> > > Select a cell in that MSWord table
> > > Format|Columns and choose 4 (or what you want)
> > >
> > > Depending on how things fit, you may have to change margins/font size/column
> > > widths/space between columns and maybe orientation (landscape???).
> > >
> > > Any time you want to insert a new row, just select an existing row, and
> > > rightclick on the selection and choose Insert|Row.
> > >
> > > You can be nice and insert it where it needs to be -- or you can sort the table
> > > after all the inserting is done. That can be found under Table|sort.
> > >
> > > (I used Office 2003 for my menus.)
> > >
> > > ===
> > > In fact, if you like to do the typing in excel, you can keep it a nice 2 column
> > > list, insert/sort as much as you want. Then just copy|paste and format in
> > > MSWord before you print.
> > >
> > >
> > >
> > >
> > >
> > > Old Bob wrote:
> > > >
> > > > Thanks Dave, I do not know much about word's sorting and formatting but I can
> > > > learn. I am a DJ and these are song books I print for the clients and 400
> > > > pages are way too much. Are there any simple instructions you can give me to
> > > > get me started after I get the data into word or do I just have to tough it
> > > > out through the work help? I would like a section for each letter and was
> > > > unaware word would sort.
> > > > --
> > > > Old Bob
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > If you're only using it as a list (no formulas), I'd copy and paste into
> > > > > MSWord. Then you can use its formatting/sorting capability.
> > > > >
> > > > >
> > > > >
> > > > > Old Bob wrote:
> > > > > >
> > > > > > I have an alphabetical list of songs in two colums-one for title and one for
> > > > > > artist. The list now is way too long (400 pages). Is there an easy way to
> > > > > > make this list in 4 colums and still keep it alphabetical?
> > > > > >
> > > > > > --
> > > > > > Old Bob
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>