Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alphabetizing
How do I alphabetize column A, while keeping the corresponding info in column
B in the correct place? |
#2
|
|||
|
|||
Hi Jordangirl78
Select all cells in column A first before you Sort -- Regards Ron de Bruin http://www.rondebruin.nl "Jordangirl78" wrote in message ... How do I alphabetize column A, while keeping the corresponding info in column B in the correct place? |
#3
|
|||
|
|||
Not sure what you mean. Can you give some sample data / layout? -- Alex Delamain ------------------------------------------------------------------------ Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273 View this thread: http://www.excelforum.com/showthread...hreadid=275339 |
#4
|
|||
|
|||
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 "Jordangirl78" wrote... How do I alphabetize column A, while keeping the corresponding info in column B in the correct place? |
#5
|
|||
|
|||
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 "David McRitchie" wrote in message ... 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 "Jordangirl78" wrote... How do I alphabetize column A, while keeping the corresponding info in column B in the correct place? |
#6
|
|||
|
|||
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 "Jordangirl78" wrote: How do I alphabetize column A, while keeping the corresponding info in column B in the correct place? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|