Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my excel have numbered columns and rows | Excel Discussion (Misc queries) | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Rows and columns | New Users to Excel |