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.
Thanks,
Jon
|