How can I sort one column and have the entire row sort. (binding)

I have my client list in rows. One row per client. The last column in the
each row has the state abriviation. I want to sort this column and have my
client list sorted by state. I need to bind the rows as a unit. Because when
I sort the last column the states sort, but they don't carry the entire row
with them. Please help.

Select all used columns before sorting. When you do the sort of the state
column, the other will follow.
--
Gary''s Student


"Blue" wrote:

> I have my client list in rows. One row per client. The last column in the
> each row has the state abriviation. I want to sort this column and have my
> client list sorted by state. I need to bind the rows as a unit. Because when
> I sort the last column the states sort, but they don't carry the entire row
> with them. Please help.

Gary"s Student,
I tried selecting all used columns, but they are all merged in different
sizes. It just sorts the single column of states. Do I just highlight the
column letter on the top to select them?

"Gary''s Student" wrote:

>
> Select all used columns before sorting. When you do the sort of the state
> column, the other will follow.
> --
> Gary''s Student
>
>
> "Blue" wrote:
>
> > I have my client list in rows. One row per client. The last column in the
> > each row has the state abriviation. I want to sort this column and have my
> > client list sorted by state. I need to bind the rows as a unit. Because when
> > I sort the last column the states sort, but they don't carry the entire row
> > with them. Please help.

In fact, go to the upper left hand corner and select the entire sheet. Then
sort by the state column.
--
Gary''s Student


"Blue" wrote:

> Gary"s Student,
> I tried selecting all used columns, but they are all merged in different
> sizes. It just sorts the single column of states. Do I just highlight the
> column letter on the top to select them?
>
> "Gary''s Student" wrote:
>
> >
> > Select all used columns before sorting. When you do the sort of the state
> > column, the other will follow.
> > --
> > Gary''s Student
> >
> >
> > "Blue" wrote:
> >
> > > I have my client list in rows. One row per client. The last column in the
> > > each row has the state abriviation. I want to sort this column and have my
> > > client list sorted by state. I need to bind the rows as a unit. Because when
> > > I sort the last column the states sort, but they don't carry the entire row
> > > with them. Please help.

If you are still having trouble read:

http://www.contextures.com/xlSort01.html
--
Gary''s Student


"Gary''s Student" wrote:

> In fact, go to the upper left hand corner and select the entire sheet. Then
> sort by the state column.
> --
> Gary''s Student
>
>
> "Blue" wrote:
>
> > Gary"s Student,
> > I tried selecting all used columns, but they are all merged in different
> > sizes. It just sorts the single column of states. Do I just highlight the
> > column letter on the top to select them?
> >
> > "Gary''s Student" wrote:
> >
> > >
> > > Select all used columns before sorting. When you do the sort of the state
> > > column, the other will follow.
> > > --
> > > Gary''s Student
> > >
> > >
> > > "Blue" wrote:
> > >
> > > > I have my client list in rows. One row per client. The last column in the
> > > > each row has the state abriviation. I want to sort this column and have my
> > > > client list sorted by state. I need to bind the rows as a unit. Because when
> > > > I sort the last column the states sort, but they don't carry the entire row
> > > > with them. Please help.

Gary, When I select the whole sheet and then hold ctrl and select the top
cell in the state column and sort. Message says can't select multi-columns.
Try one only. So when I do it sorts states only.

"Gary''s Student" wrote:

> In fact, go to the upper left hand corner and select the entire sheet. Then
> sort by the state column.
> --
> Gary''s Student
>
>
> "Blue" wrote:
>
> > Gary"s Student,
> > I tried selecting all used columns, but they are all merged in different
> > sizes. It just sorts the single column of states. Do I just highlight the
> > column letter on the top to select them?
> >
> > "Gary''s Student" wrote:
> >
> > >
> > > Select all used columns before sorting. When you do the sort of the state
> > > column, the other will follow.
> > > --
> > > Gary''s Student
> > >
> > >
> > > "Blue" wrote:
> > >
> > > > I have my client list in rows. One row per client. The last column in the
> > > > each row has the state abriviation. I want to sort this column and have my
> > > > client list sorted by state. I need to bind the rows as a unit. Because when
> > > > I sort the last column the states sort, but they don't carry the entire row
> > > > with them. Please help.

it is saying all merged cell have to be the same size.
"Gary''s Student" wrote:

> If you are still having trouble read:
>
> http://www.contextures.com/xlSort01.html
> --
> Gary''s Student
>
>
> "Gary''s Student" wrote:
>
> > In fact, go to the upper left hand corner and select the entire sheet. Then
> > sort by the state column.
> > --
> > Gary''s Student
> >
> >
> > "Blue" wrote:
> >
> > > Gary"s Student,
> > > I tried selecting all used columns, but they are all merged in different
> > > sizes. It just sorts the single column of states. Do I just highlight the
> > > column letter on the top to select them?
> > >
> > > "Gary''s Student" wrote:
> > >
> > > >
> > > > Select all used columns before sorting. When you do the sort of the state
> > > > column, the other will follow.
> > > > --
> > > > Gary''s Student
> > > >
> > > >
> > > > "Blue" wrote:
> > > >
> > > > > I have my client list in rows. One row per client. The last column in the
> > > > > each row has the state abriviation. I want to sort this column and have my
> > > > > client list sorted by state. I need to bind the rows as a unit. Because when
> > > > > I sort the last column the states sort, but they don't carry the entire row
> > > > > with them. Please help.

I keep get the note about merged cell must be exact size. I have adjusted
the rows and columns to have all the merged cells the same size. I click on
upper left corner to select the worksheet. Go to the pulldown of sort under
data and chose the state column for the sort. AND THE NOTE pops up about the
merged cells. I Know they are the exact size. What is causing this?? Need a
little Help. Take care, Blue
"Blue" wrote:

> Gary, When I select the whole sheet and then hold ctrl and select the top
> cell in the state column and sort. Message says can't select multi-columns.
> Try one only. So when I do it sorts states only.
>
> "Gary''s Student" wrote:
>
> > In fact, go to the upper left hand corner and select the entire sheet. Then
> > sort by the state column.
> > --
> > Gary''s Student
> >
> >
> > "Blue" wrote:
> >
> > > Gary"s Student,
> > > I tried selecting all used columns, but they are all merged in different
> > > sizes. It just sorts the single column of states. Do I just highlight the
> > > column letter on the top to select them?
> > >
> > > "Gary''s Student" wrote:
> > >
> > > >
> > > > Select all used columns before sorting. When you do the sort of the state
> > > > column, the other will follow.
> > > > --
> > > > Gary''s Student
> > > >
> > > >
> > > > "Blue" wrote:
> > > >
> > > > > I have my client list in rows. One row per client. The last column in the
> > > > > each row has the state abriviation. I want to sort this column and have my
> > > > > client list sorted by state. I need to bind the rows as a unit. Because when
> > > > > I sort the last column the states sort, but they don't carry the entire row
> > > > > with them. Please help.

*Unmerge* your cells, and use "Center Across Selection" instead.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Blue" <[email protected]> wrote in message
news:[email protected]...
>
> I keep get the note about merged cell must be exact size. I have adjusted
> the rows and columns to have all the merged cells the same size. I click
on
> upper left corner to select the worksheet. Go to the pulldown of sort
under
> data and chose the state column for the sort. AND THE NOTE pops up about
the
> merged cells. I Know they are the exact size. What is causing this??
Need a
> little Help. Take care, Blue
> "Blue" wrote:
>
> > Gary, When I select the whole sheet and then hold ctrl and select the
top
> > cell in the state column and sort. Message says can't select
multi-columns.
> > Try one only. So when I do it sorts states only.
> >
> > "Gary''s Student" wrote:
> >
> > > In fact, go to the upper left hand corner and select the entire sheet.
Then
> > > sort by the state column.
> > > --
> > > Gary''s Student
> > >
> > >
> > > "Blue" wrote:
> > >
> > > > Gary"s Student,
> > > > I tried selecting all used columns, but they are all merged in
different
> > > > sizes. It just sorts the single column of states. Do I just
highlight the
> > > > column letter on the top to select them?
> > > >
> > > > "Gary''s Student" wrote:
> > > >
> > > > >
> > > > > Select all used columns before sorting. When you do the sort of
the state
> > > > > column, the other will follow.
> > > > > --
> > > > > Gary''s Student
> > > > >
> > > > >
> > > > > "Blue" wrote:
> > > > >
> > > > > > I have my client list in rows. One row per client. The last
column in the
> > > > > > each row has the state abriviation. I want to sort this column
and have my
> > > > > > client list sorted by state. I need to bind the rows as a unit.
Because when
> > > > > > I sort the last column the states sort, but they don't carry the
entire row
> > > > > > with them. Please help.

RAG DUDE,
This worked Great. I thank you for your help. When I am making columns of
data, is it best to leave them unmerged?
"Ragdyer" wrote:

> *Unmerge* your cells, and use "Center Across Selection" instead.
>
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Blue" <[email protected]> wrote in message
> news:[email protected]...
> >
> > I keep get the note about merged cell must be exact size. I have adjusted
> > the rows and columns to have all the merged cells the same size. I click
> on
> > upper left corner to select the worksheet. Go to the pulldown of sort
> under
> > data and chose the state column for the sort. AND THE NOTE pops up about
> the
> > merged cells. I Know they are the exact size. What is causing this??
> Need a
> > little Help. Take care, Blue
> > "Blue" wrote:
> >
> > > Gary, When I select the whole sheet and then hold ctrl and select the
> top
> > > cell in the state column and sort. Message says can't select
> multi-columns.
> > > Try one only. So when I do it sorts states only.
> > >
> > > "Gary''s Student" wrote:
> > >
> > > > In fact, go to the upper left hand corner and select the entire sheet.
> Then
> > > > sort by the state column.
> > > > --
> > > > Gary''s Student
> > > >
> > > >
> > > > "Blue" wrote:
> > > >
> > > > > Gary"s Student,
> > > > > I tried selecting all used columns, but they are all merged in
> different
> > > > > sizes. It just sorts the single column of states. Do I just
> highlight the
> > > > > column letter on the top to select them?
> > > > >
> > > > > "Gary''s Student" wrote:
> > > > >
> > > > > >
> > > > > > Select all used columns before sorting. When you do the sort of
> the state
> > > > > > column, the other will follow.
> > > > > > --
> > > > > > Gary''s Student
> > > > > >
> > > > > >
> > > > > > "Blue" wrote:
> > > > > >
> > > > > > > I have my client list in rows. One row per client. The last
> column in the
> > > > > > > each row has the state abriviation. I want to sort this column
> and have my
> > > > > > > client list sorted by state. I need to bind the rows as a unit.
> Because when
> > > > > > > I sort the last column the states sort, but they don't carry the
> entire row
> > > > > > > with them. Please help.
>
>

Absolutely!

What you came up against is only one of the many problems that "Merge"
causes.

To be used only as the ultimate "last resort".

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Blue" <[email protected]> wrote in message
news:[email protected]...
>
> RAG DUDE,
> This worked Great. I thank you for your help. When I am making columns of
> data, is it best to leave them unmerged?
> "Ragdyer" wrote:
>
> > *Unmerge* your cells, and use "Center Across Selection" instead.
> >
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> > "Blue" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > I keep get the note about merged cell must be exact size. I have
adjusted
> > > the rows and columns to have all the merged cells the same size. I
click
> > on
> > > upper left corner to select the worksheet. Go to the pulldown of sort
> > under
> > > data and chose the state column for the sort. AND THE NOTE pops up
about
> > the
> > > merged cells. I Know they are the exact size. What is causing this??
> > Need a
> > > little Help. Take care, Blue
> > > "Blue" wrote:
> > >
> > > > Gary, When I select the whole sheet and then hold ctrl and select
the
> > top
> > > > cell in the state column and sort. Message says can't select
> > multi-columns.
> > > > Try one only. So when I do it sorts states only.
> > > >
> > > > "Gary''s Student" wrote:
> > > >
> > > > > In fact, go to the upper left hand corner and select the entire
sheet.
> > Then
> > > > > sort by the state column.
> > > > > --
> > > > > Gary''s Student
> > > > >
> > > > >
> > > > > "Blue" wrote:
> > > > >
> > > > > > Gary"s Student,
> > > > > > I tried selecting all used columns, but they are all merged in
> > different
> > > > > > sizes. It just sorts the single column of states. Do I just
> > highlight the
> > > > > > column letter on the top to select them?
> > > > > >
> > > > > > "Gary''s Student" wrote:
> > > > > >
> > > > > > >
> > > > > > > Select all used columns before sorting. When you do the sort
of
> > the state
> > > > > > > column, the other will follow.
> > > > > > > --
> > > > > > > Gary''s Student
> > > > > > >
> > > > > > >
> > > > > > > "Blue" wrote:
> > > > > > >
> > > > > > > > I have my client list in rows. One row per client. The last
> > column in the
> > > > > > > > each row has the state abriviation. I want to sort this
column
> > and have my
> > > > > > > > client list sorted by state. I need to bind the rows as a
unit.
> > Because when
> > > > > > > > I sort the last column the states sort, but they don't carry
the
> > entire row
> > > > > > > > with them. Please help.
> >
> >

@Gary, thx it worked like a charm xo