tagging rows to columns???
 

I just created an excel catalog for my cd jukebox as I loaded the tray (300
discs). Now I want to alphabetize column A (artist) and have column B
(album title) follow column A. Is there a way to do this?

Thanks for all help.
beo

Try on a duplicate copy of your sheet:

Assuming your lists are in cols A and B,
data from row2 down, viz.:

Artist Title
ABC Text1
XYZ Text2
DEF Text3
etc

Select cols A and B

Click Data Sort

Check "Header row" under "My list has"

Ensure settings
under "Sort by" a Artist Ascending

Click OK

For the sample data above, you'll get:

Artist Title
ABC Text1
DEF Text3
XYZ Text2

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"john smith" wrote in message
...
I just created an excel catalog for my cd jukebox as I loaded the tray
(300
discs). Now I want to alphabetize column A (artist) and have column B
(album title) follow column A. Is there a way to do this?

Thanks for all help.
beo

Just make sure you select the entire range of data before you sort, ie Col A AND
Col B, AND any other columns that contain data

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"john smith" wrote in message
...
I just created an excel catalog for my cd jukebox as I loaded the tray (300
discs). Now I want to alphabetize column A (artist) and have column B (album
title) follow column A. Is there a way to do this?

Thanks for all help.
beo