 |
 | 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 / October 2006Please HElp.
I am using excel as a magazine order data base. I would like to place all the rows in alphabetical order base on collumm A, the first collumm. I am using excel 2000. I know how to do this using Excel 2003, so i dont know what the difference should be? SO far if i click on the first cell or row number and hit the ascending button it will put collumm A in alphabetical order. But ,I need all the other collumms to follow with the collumm A. Thanks for any help .-- Gonzo~ Gonzo, Nearly there...just make sure you select ALL of your data before sorting into alphabetical order (i.e. select all data in range, sort by column A (ascending)). Excel also lets you sort by more than one key i.e. column A is your primary key, you may want B to be a secondary key etc. e.g. Column A contains surnames: Smith Smith Column B contains initial C D Sorting by column A alone won't necessarily get the right results - sort by column A, then B etc. - just thought I'd let you know... > I am using excel as a magazine order data base. I would like to place all the > rows in alphabetical order base on collumm A, the first collumm. I am using [quoted text clipped - 6 lines] > collumms to follow with the collumm A. Thanks for any help .-- > Gonzo~ look in the help index for SORT  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com >I am using excel as a magazine order data base. I would like to place all >the [quoted text clipped - 9 lines] > collumms to follow with the collumm A. Thanks for any help .-- > Gonzo~ Stupid question? Where in excel 2000 is the help index. SignatureGonzo~ > look in the help index for SORT > [quoted text clipped - 11 lines] > > collumms to follow with the collumm A. Thanks for any help .-- > > Gonzo~ Press F1 or click Help, then select the Index tab - I'm sure this will be the same as in XL2003 (I also have XL2000). Hope this helps. Pete > Stupid question? Where in excel 2000 is the help index. > -- [quoted text clipped - 19 lines] > > > collumms to follow with the collumm A. Thanks for any help .-- > > > Gonzo~ You could look at the menu bar for HELP SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Stupid question? Where in excel 2000 is the help index. > [quoted text clipped - 15 lines] >> > collumms to follow with the collumm A. Thanks for any help .-- >> > Gonzo~
|
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.