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.

Thanks,

Jon

Hi Jon,

I believe you're looking for this
http://office.microsoft.com/en-us/ex...739411033.aspx

Kind regards,
Wries

Thank you, Wries; much appreciated.

Jon