View Single Post
Old 08-20-2009, 04:10 PM
Jonre Jonre is offline Windows Vista Office 2007
Join Date: Aug 2009
Posts: 2
Jonre is on a distinguished road
Default Sorting columns in Excel - please advise

Hi everyone,

I'm very new to Excel, and I can't seem to find a simple way to accomplish what I want to do.

Say I have a spreadsheet with three columns: Name, City, and Zip Code.

Once I have some data, say I have ten rows filled, how do I sort each column and keep each row intact?

In other words, I want to sort by city; how do I do this without only that column changing. If Bob Smith is in Chicago, I don't want him jumping to Walla Walla during the sort.

I hope this makes sense, and I hope someone can help.


Reply With Quote