 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008A column sorting question..
I have 5 columns with rows that go to inifinity. I would like to sort the first column which is a LAST NAME A column alphabetically. If I do this, I also need to have rows B C D and E follow that sort. Is this possible? Thanks! Hi Terri Highlight all columns A to E go to menu - Data-Sort select just the first one, if you have a Header in A!-B1 etc you can select in that menu " Have Header". You don't wont to sort the Headers. If the resolt is not what you expect you can "Undo Sort" Regards Cimjet >I have 5 columns with rows that go to inifinity. I would like to sort the >first column which is a LAST NAME A column alphabetically. If I do this, I >also need to have rows B C D and E follow that sort. Is this possible? > Thanks! ME Again In the sort menu, the first window you select sort by " Column A " second and third window don't touch. Regards Cimjet >I have 5 columns with rows that go to inifinity. I would like to sort the >first column which is a LAST NAME A column alphabetically. If I do this, I >also need to have rows B C D and E follow that sort. Is this possible? > Thanks!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.