View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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?