tagging rows?

[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.

 

[Gord Dibben]

John

Make sure you have both columns A and B selected then Data>Sort.

Pick column A to sort by in ascending order.

Also note the option buttons for "header row"

Gord Dibben Excel MVP

 

[john smith]

I tried your suggestion, but I get a window that says: The command you
chose cannot be performed with multiple selections. Select a single range
and click the command again. I also have created an additional numbered
column to denote the cd number that I would like to follow the artists
alphabetical name. In other words, I would like column A and C to follow
column B when B is sorted aphabetically. Can this even happen? Thanks for
your time. John

 

[CLR]

Maybe you've got some "merged" cells.........they won't sort

Vaya con Dios,
Chuck, CABGx3

 

[Ken Wright]

Is your data filtered by any chance, such that when you select the range you end
up selecting only visible cells?