Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort rows keeping columns together?
I have an excel ws with information divided into columns (Name, address,
phone, e-mail, etc...)--how do I alphabetize the names (rows) while still keeping the information about each person together? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort rows keeping columns together?
Select the *entire* datalist yourself ... THEN sort!
NEVER leave the choice to XL. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "A123" wrote in message ... I have an excel ws with information divided into columns (Name, address, phone, e-mail, etc...)--how do I alphabetize the names (rows) while still keeping the information about each person together? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort rows keeping columns together?
Hi,
Select all your data (not just one column), then sort. Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Columns and Rows around to sort | Excel Discussion (Misc queries) | |||
How to sort data from rows into columns? | Excel Discussion (Misc queries) | |||
Sort on rows (not columns) | Excel Discussion (Misc queries) | |||
How do I sort numbers in a table (ie. rows & columns)? | Excel Discussion (Misc queries) | |||
keeping rows intact during sort | Excel Discussion (Misc queries) |