I have an alphabetical list of songs in two colums-one for title and one for
artist. My 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

You mean with the same two columns split into 4 or want to add another two
details column?
Sort is simply the best option you can use Automatic Filter option from Data
Menu.

and if you plan to take prints
go to nearly the half of the excel sheet
cut it from there and paste next to data in top





"Old Bob" wrote in message
...
I have an alphabetical list of songs in two colums-one for title and one
for
artist. My 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, I wanted to now make 4 columns but keep all the A's, B's ect together.
--
Old Bob


"sajay" wrote:

You mean with the same two columns split into 4 or want to add another two
details column?
Sort is simply the best option you can use Automatic Filter option from Data
Menu.

and if you plan to take prints
go to nearly the half of the excel sheet
cut it from there and paste next to data in top





"Old Bob" wrote in message
...
I have an alphabetical list of songs in two colums-one for title and one
for
artist. My 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

On Jul 7, 11:00 am, Old Bob wrote:
Thanks, I wanted to now make 4 columns but keep all the A's, B's ect together.
--
Old Bob

"sajay" wrote:
You mean with the same two columns split into 4 or want to add another two
details column?
Sort is simply the best option you can use Automatic Filter option from Data
Menu.

and if you plan to take prints
go to nearly the half of the excel sheet
cut it from there and paste next to data in top

"Old Bob" wrote in message
...
I have an alphabetical list of songs in two colums-one for title and one
for
artist. My 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
How many songs do you add in a week? You could switch to Word. It
allows for multiple print columns, like a newspaper. And can still
Sort.

I mean that currently I have a column for song and one for artist on each
page, I would like to add a third column for song and a fourth for artist so
what was once on two pages can go on one page...
--
Old Bob


"Spiky" wrote:

On Jul 7, 11:00 am, Old Bob wrote:
Thanks, I wanted to now make 4 columns but keep all the A's, B's ect together.
--
Old Bob

"sajay" wrote:
You mean with the same two columns split into 4 or want to add another two
details column?
Sort is simply the best option you can use Automatic Filter option from Data
Menu.

and if you plan to take prints
go to nearly the half of the excel sheet
cut it from there and paste next to data in top

"Old Bob" wrote in message
...
I have an alphabetical list of songs in two colums-one for title and one
for
artist. My 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
How many songs do you add in a week? You could switch to Word. It
allows for multiple print columns, like a newspaper. And can still
Sort.

I mean that currently I have a column for song and one for artist on each
page, I would like to add a third column for song and a fourth for artist so
what was once on two pages can go on one page...


Yep, that's what I assumed. Excel doesn't do Sort (not easily, I
presume someone could write VBA to do it) when the data wraps to a 2nd
set of columns. Word does, hence my suggestion.

You could also try changing printing prefs to print 2 pages on one in
Print Options. But I think this will make it too small to read.