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: Today @ 7:04:10 PM
Posts: 331, Visits: 1,204
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

S-t-i-l-l in session 15.

Member AHDI

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


Forum Guru

Forum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum Guru

Group: Forum Members
Last Login: 12/1/2009 4:39:32 PM
Posts: 71, Visits: 444
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 (19 views, 139.05 KB)
after.jpg (12 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: Today @ 7:04:10 PM
Posts: 331, Visits: 1,204
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

S-t-i-l-l in session 15.

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 @ 5:49:49 PM
Posts: 353, Visits: 2,003
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 8:09pm

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.219. 7 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.