M-TEC Message Forum
M-TEC Home     Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



alphabetizing words Expand / Collapse
Author
Message
Posted 6/4/2009 11:14:13 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: M-TEC Student
Last Login: Yesterday @ 6:21:35 PM
Posts: 415, Visits: 1,623
I read about people going to Excel to alphabetize their word lists but I dont see any way to do it. I have teh 2003 version and when I type in HELP to find how it dont come up. Does anyone have the 2004 that is alphbetizing? Thanks Sharon

 ON TO 15 ( old 17) YES ! There is a dim light at the end of the tunnel.

Member AHDI

Post #125081
Posted 6/4/2009 11:25:41 PM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 7/14/2010 3:52:24 PM
Posts: 76, Visits: 462
You highlight the column you want to alphabetize and then you should see an icon or something up top (I have 2007) that says "sort & filter".  Then it will give you the option to sort A-Z, Z-A or a custom sort.

See the screen shot pic attachments I added.

Misty O'Neal

"Wannabe M-Tec Student" - Future MT Student starting in June.



  Post Attachments 
before.JPG (22 views, 139.05 KB)
after.jpg (15 views, 136.52 KB)
Post #125082
Posted 6/5/2009 6:51:30 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: M-TEC Student
Last Login: Yesterday @ 6:21:35 PM
Posts: 415, Visits: 1,623
Thanks Misty. I see you only have 3 days left until you start school. How long is the course?Enjoy your last few days of peace before you start stressing out with the rest of us Sharon

 ON TO 15 ( old 17) YES ! There is a dim light at the end of the tunnel.

Member AHDI

Post #125088
Posted 6/5/2009 8:24:24 AM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: M-TEC Graduate
Last Login: Today @ 11:28:37 AM
Posts: 390, Visits: 2,228
make sure you don't just sort a column if you have other associated columns like definition and source, etc.  You can select all and go to Data, sort, and then select the columns you want to sort on.  Make sure if you have a row with headings at the top that you indicate "heading" in a little check box, that way your heading row will not be alphabetized into the list.  This is the main reason I have kept my TC in Excel from the beginning -- the sort option!

Anita Sale

Graduated and employed October 2009
Member, AHDI, OA-AHDI
Post #125092
« Prev Topic | Next Topic »


Permissions Expand / Collapse

All times are GMT -5:00, Time now is 12:32pm

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.141. 10 queries. Compression Disabled.

Privacy Policy | Help | Contact Us

Copyright © 1996-2009 M-TEC, Inc. All Rights Reserved.
M-TEC® is a registered trademark of Medical Transcription Education Center, Inc.
Email Webmaster with comments.