How do I sort rows keeping columns together?

's Computer Specifications

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?

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:1CBFC5FE-42C8-46E9-BD4F-(E-Mail Removed)...
>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?

's Computer Specifications

Hi,
Select all your data (not just one column), then sort.
Regards - Dave.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
remove duplicate rows but keeping all columns	DC	Microsoft Excel Worksheet Functions	3	10th Jun 2009 03:10 AM
sort column by date but keeping all rows locked	Josh	Microsoft Excel Misc	3	5th Apr 2009 08:09 PM
Keeping certain columns/rows visible	MichaelPhilips	Microsoft Excel Misc	2	8th Jan 2009 05:40 PM
Sort by color: Is there an easy way to sort columns or rows in EX	MGP	Microsoft Excel Worksheet Functions	5	16th Aug 2008 11:28 AM
keeping rows intact during sort	=?Utf-8?B?Smlt?=	Microsoft Excel Misc	2	25th Nov 2005 01:59 AM