grouping cells to sort by only one column

[Caauwe1]

Hi,
New to this so please bear with me.

I have a spread sheet where I am listing names in column A and othe
info relating to that name in columns B and C in the two rows below th
name.
I then start a different name in the next row down with the info in t
two rows below that, and so forth.

I want to be able to add more names in the future and be able to sor
all of this by column A only. The problem I am having is the info i
the other columns moves. I need it to somehow attatch and stay put wit
it's corisponding name without moving.

In other words how do I make everything from A1 to C3 become one larg
cell or block and be able to just sort by using Column A?

Any idea?

Thank You in advance!

Caauwe

 

[duane]

if you select the whole range as arhe are to sort you can still sort th
whole block on the basis of column a only, and the info in columns
and c will stay with the column a info. the problem I see is the tw
rows below your names will not stick with the names after you sort

 

[Reinboux]

I am a little confused by your description but I will do the best that I can to help you.
You say that you are listing names in 'column A' and other info relating in 'column B & C' in the two rows below the name. This is where I am confused. Are you listing them in the columns or the rows?
The rows are numbered and the columns are lettered. Also are you trying to sort by first name or last name?
What I recommend you do is this:
Place the last name in cell A4, the first name in B4, and the corresponding information for that name in C4. When you start the information for the second person, place the last name in A5, first name in B5, and corresponding info in C5, etc. (A4, B4, C4...A5, B5, C5...A6, B6, C6...) That way you have the person's name and info in a horizontal format instead of a vertical format.
Once you are ready to sort, you can click the Last name, or First name (depending on how you want to sort it) of the first person in your list (A4) and click the AZ sorter button. All info from that cell down will sort along with all the corresponding info for that person.
I hope that this helps! I will be checking this post in the future to see if it does. Good Luck!

 

[Debra Dalgleish]

If possible, enter all the items in one row. If you need a line break in
a cell, press Alt+Enter.

Or, repeat the name in rows two and three, and hide the duplicate
entries with conditional formatting. There are instructions here:

http://www.contextures.com/xlCondFormat03.html#Duplicate

 

[CLR]

Hi........

You cannot sort on column A and have blank spaces in it and expect the
associated data in columns B and C to stay wth each name...........Column A
must have sequential data in every cell to keep the association,
.............for instance, if you have Jones in A1, 123 MyStreet in B2, and
MyTown,MyState in C3...........you can keep the association all together if
you change A1 to Jones01, and put Jones02 in A2, and Jones03 in
A3...............then when you sort on column A, the associated items in B
and C will stay with each name.........then the next name Smith01 in A4,
Smith02 in A5, and Smith03 in A6, etc etc etc.........

hth
Vaya con Dios,
Chuck, CABGx3

 

[duane]

hers is an idea. if your 1st name is in cell a1, then make cell a2 =a
and format the font of cell a2 so it is invisible. then you can sor
by column a

 

[Guest]

-----Original Message-----
Hi,
New to this so please bear with me.

I have a spread sheet where I am listing names in column A and other
info relating to that name in columns B and C in the two rows below the
name.
I then start a different name in the next row down with the info in th
two rows below that, and so forth.

I want to be able to add more names in the future and be able to sort
all of this by column A only. The problem I am having is the info in
the other columns moves. I need it to somehow attatch and stay put with
it's corisponding name without moving.

In other words how do I make everything from A1 to C3 become one large
cell or block and be able to just sort by using Column A?

Any idea?

Thank You in advance!

Caauwe1

Hope this answers your question. You can either merge
cells so that they all become one cell, or you can freeze
those cells so that they don't move and are always found
at the top of the worksheet. If you want to merge the
cells you highlight the cells you want to merge and then
go to format, cells. If you want to freeze them, do a
search for "Freeze Cells" b/c I can't give you very
detailed instructions off the top of my head.