Alphabetizing

[Guest]

How do I alphabetize column A, while keeping the corresponding info in column
B in the correct place?

 

[Ron de Bruin]

Hi Jordangirl78

Select all cells in column A first before you Sort

 

[Alex Delamain]

Not sure what you mean. Can you give some sample data / layout

 

[David McRitchie]

Depends on what you mean by the correct place.
Ron's answer to select Column A and sort that column independently of all other data,
so that data in other columns does not move at all.

If you want to sort column A and bring with it all of the row then you would select
all columns on the worksheet before sorting, then to sort use Data, Sort,
Column A and probably [x] data has headers. Which I think better matches
corresponding.

I would suggest you NEVER rely on Excel's choice of extending a single cell
to the current range -- sooner or later you would destroy your data on some
worksheet..

More information on sorting in
http://www.mvps.org/dmcritchie/excel/sorting.htm

Please try to make questions as clear as possible, US English is my language
and I can't tell for sure what your question is -- I wouldn't expect those whose
language is not English to make a better guess.

 

[Ron de Bruin]

Hi David

Please try to make questions as clear as possible

After reading the question again I maybe didn't understand the OP correct.


--
Regards Ron de Bruin
http://www.rondebruin.nl

Depends on what you mean by the correct place.
Ron's answer to select Column A and sort that column independently of all other data,
so that data in other columns does not move at all.

If you want to sort column A and bring with it all of the row then you would select
all columns on the worksheet before sorting, then to sort use Data, Sort,
Column A and probably [x] data has headers. Which I think better matches
corresponding.

I would suggest you NEVER rely on Excel's choice of extending a single cell
to the current range -- sooner or later you would destroy your data on some
worksheet..

More information on sorting in
http://www.mvps.org/dmcritchie/excel/sorting.htm

Please try to make questions as clear as possible, US English is my language
and I can't tell for sure what your question is -- I wouldn't expect those whose
language is not English to make a better guess.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

How do I alphabetize column A, while keeping the corresponding info in column
B in the correct place?

 

[Guest]

hi,
As I understand from your question,you want column A in alphabetical order
and to show the corresponding values in B.if so,please try.
Select first column A from top to bottom with mouse and then column B
without lifting the mouse button.Then use sort option.This will give you the
desired result.
Thank you,
K.S.warrier