Halp! How do you

[EmilieMadison]

sort a column alphabetically in excel? Well, I mean, I know how to do that, but can you sort one column and have the column next to it also change so that the info lines up the way it was? For example, say column A is a name and B is a phone number and if you alphabetize A, have the right phone number in B stay with the coordinating name from A?  

[zoidberg]

Highlight them both. I think the command you want is under data -> sort -> advanced ?? sort

Anyway, you can choose to sort by column A.

[revolution]

which excel are you using? 2010?

[glassofsyrah]

Yes, highlight them both and then apply the sorting.

[Deleted]

What version of excel do you have? You highlight the column that you want to alphabetize then on the Home tab there should be a sort and filter button with a AZ on it. Press that and it will come up and ask you if you want to Expand the Selection and that's the one you want. That way it will alphabetize everything. That's with Word 2010 btw.

[melindafelinda]

May 2, 2013 15:13:36 GMT -5 @kimberhenry said:

What version of excel do you have? You highlight the column that you want to alphabetize then on the Home tab there should be a sort and filter button with a AZ on it. Press that and it will come up and ask you if you want to Expand the Selection and that's the one you want. That way it will alphabetize everything. That's with Word 2010 btw.

Yup

[underwaterrhymes]

You will also want to click the box that indicates whether or not you have headers, otherwise your headers might get pulled into the sort too.

[EmilieMadison]

I have version 2010- THANK YOU!