Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-20-2009, 04:10 PM
Jonre Jonre is offline Windows Vista Office 2007
Novice
 
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.

Thanks,

Jon
Reply With Quote
  #2  
Old 08-21-2009, 02:01 AM
Wries Wries is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Jun 2009
Posts: 40
Wries is on a distinguished road
Default

Hi Jon,

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

Kind regards,
Wries
Reply With Quote
  #3  
Old 08-21-2009, 02:38 AM
Jonre Jonre is offline Windows Vista Office 2007
Novice
 
Join Date: Aug 2009
Posts: 2
Jonre is on a distinguished road
Default

Thank you, Wries; much appreciated.

Jon
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
Re Formatting Columns? erikjen Word 0 02-16-2009 12:25 AM
Sorting Tasks by Contacts Bat Outlook 0 09-24-2007 01:20 PM
Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM
sheet linking, sorting nickbfe Excel 0 05-19-2006 11:00 AM


All times are GMT -7. The time now is 10:21 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft