Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change how cells are sorted in an excel file?
I am working on an Excel file in which I have several columns. I need to sort
the information alphabetically by the middle column, however, I also need the information in the first columns to stay with the information in the middle columns. For example my columns are like this: Mr/Ms First Name Last Name Company Address ETC... I need to sort by Company but I need the other information to stay with the respected company. Is this making any sense? Can someone help? |
#2
|
|||
|
|||
How do I change how cells are sorted in an excel file?
Tizzy,
Select all the columns prior to doing the sort. The information in the other columns will move based on the column selected as the sorting key. HTH, Bernie MS Excel MVP "Tizzylish2003" wrote in message ... I am working on an Excel file in which I have several columns. I need to sort the information alphabetically by the middle column, however, I also need the information in the first columns to stay with the information in the middle columns. For example my columns are like this: Mr/Ms First Name Last Name Company Address ETC... I need to sort by Company but I need the other information to stay with the respected company. Is this making any sense? Can someone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
How do you change the destination of "print to file" in excel xp? | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) |