MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sorting problems


Posted by marcus on August 15, 2001 10:59 AM

In my excel(2000) spreadsheet, how can I do a sort without mixing up all my information??

Ex If I have a speadsheet with seperate information in each colum.. lastname / first name / address / zipcode / phone number.
Everything in order by last name, but now I want to sort by the phone number. I hi-lite the number colum press sort, now the only thing that sorted was the numbers.
Can the roll be lock together so if one item of the roll moves all of the information in that roll moves with it???


Posted by neo on August 15, 2001 11:21 AM

try highlighting all columns that have the info in them you want to sort. then go to data --> sort and in the sort box that pops up, uner the 'sort by' option, select the title of the column that you want to sort your data by (in your case, phone numbers)...

neo

Posted by Mark W. on August 15, 2001 11:22 AM

Select the entire row(s).