Re: How do I alphabetize a column but also have the corresponding cells move with the sort?

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/15/04 

Date: Sun, 15 Feb 2004 13:01:04 -0500

You should have your definitions all in one cell. Putting them on separate
rows without repeating the name in the same row in column A would cause them
to sort incorrectly. If you want to have multiple rows for a definition,
you need to have a matching value in the key field. As long as you only
sort on one column as the key, the definition's multiple rows should stay
adjacent (given you have repeated the key value in the key field for each
row). 

-- 
Regards,
Tom Ogilvy
"Back to college" <anonymous@discussions.microsoft.com> wrote in message
news:6129FEE9-A32A-4731-86E9-6D547197ADAF@microsoft.com...
> Dear Ragdyer,
>
> So far that was the best help yet.  I selected the range before just like
you said and this time the definitions and page numbers appeared "somewhat"
correctly.
>
> However, some of the definitions are longer than one row in length and I
had to continue to the next row for the remainder of the definition.  Whe I
did the sort all the lines of the definitions that were longer than one row
appeard at the end of the sort result.
>
> Is there a way to post what my *** looks like for you to be able to see
what is happening?
>
Loading