Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2009, 04:10 PM
Jonre Jonre is offline Sorting columns in Excel - please advise Windows Vista Sorting columns in Excel - please advise Office 2007
Novice
Sorting columns in Excel - please advise
 
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 Sorting columns in Excel - please advise Windows 7 64bit Sorting columns in Excel - please advise 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 Sorting columns in Excel - please advise Windows Vista Sorting columns in Excel - please advise Office 2007
Novice
Sorting columns in Excel - please advise
 
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
Sorting columns in Excel - please advise 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
Sorting columns in Excel - please advise 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft