tagging rows?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

john smith - 30 Dec 2004 00:18 GMT

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.

Reply to this Message

Gord Dibben - 30 Dec 2004 00:25 GMT

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

Reply to this Message

john smith - 30 Dec 2004 01:57 GMT

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

> John
>
[quoted text clipped - 11 lines]
>>(album title) follow column A. Is there a way to do this? Thanks for all
>>help.

Reply to this Message

CLR - 30 Dec 2004 02:06 GMT

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

Vaya con Dios,
Chuck, CABGx3

> 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
[quoted text clipped - 19 lines]
> >>(album title) follow column A. Is there a way to do this? Thanks for all
> >>help.

Reply to this Message

Ken Wright - 30 Dec 2004 09:14 GMT

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

Signature

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

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

>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
[quoted text clipped - 17 lines]
>>>(album title) follow column A. Is there a way to do this? Thanks for all
>>>help.

Reply to this Message