tagging rows?

  • 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.
 
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
 
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
 
Is your data filtered by any chance, such that when you select the range you end
up selecting only visible cells?
 
Back
Top