Prev: Unable to open embedded word document from Excel
Next: Saving in Compatibility mode takes a long time
From: Cindy Sue Cindy on 23 Feb 2010 14:55
I want to make a list of names and addresses putting name, address, city,
state, zip across in separate columns. Is there a way to attach these so
that when I alphabetize the names each of the cells in the row stay with the
correct person?
From: Luke M on 23 Feb 2010 15:01
When you go to alphabatize, aka sort the data, make sure you select ALL of
the columns.

--
Best Regards,

Luke M
"Cindy Sue" <Cindy Sue(a)discussions.microsoft.com> wrote in message
news:15D7A4A6-500E-43F6-8974-E0A661B79222(a)microsoft.com...
>I want to make a list of names and addresses putting name, address, city,
> state, zip across in separate columns. Is there a way to attach these so
> that when I alphabetize the names each of the cells in the row stay with
> the
> correct person?


From: Mike H on 23 Feb 2010 15:05
Hi,

When you do the sort select ALL the columns then in the sort wizard select
the column to sort on (Name) and all the data will stay in their respective
rows
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Cindy Sue" wrote:

> I want to make a list of names and addresses putting name, address, city,
> state, zip across in separate columns. Is there a way to attach these so
> that when I alphabetize the names each of the cells in the row stay with the
> correct person?
From: Daryl S on 23 Feb 2010 15:05
Cindy Sue -

There are two basic ways.
First, you can just select the entire range before sorting, and all rows
will remain together.
Second, you can add an AutoFilter to the data and when you sort a column,
all the other columns sort with it, keeping the records together.

--
Daryl S


"Cindy Sue" wrote:

> I want to make a list of names and addresses putting name, address, city,
> state, zip across in separate columns. Is there a way to attach these so
> that when I alphabetize the names each of the cells in the row stay with the
> correct person?
From: Bob I on 23 Feb 2010 15:05
Just make sure you select ALL the columns containing info before sorting.

Cindy Sue wrote:

> I want to make a list of names and addresses putting name, address, city,
> state, zip across in separate columns. Is there a way to attach these so
> that when I alphabetize the names each of the cells in the row stay with the
> correct person?

 |  Next  |  Last
Pages: 1 2
Prev: Unable to open embedded word document from Excel
Next: Saving in Compatibility mode takes a long time