tagging rows to columns???

  • Thread starter Thread starter john smith
  • Start date Start date
J

john smith

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" are: Artist > Ascending

Click OK

For the sample data above, you'll get:

Artist Title
ABC Text1
DEF Text3
XYZ Text2
 
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
 
Back
Top