Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Sorting lists of words
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel training - Sorting lists of words
Resolved · Low Priority · Version Standard
Reply Tue 3 Jul 2007, 16:01Delegate Chris said...
Chris has attended:
Powerpoint Intermediate Advanced course
Sorting lists of words
Is it possible to sort a list of words in the way you can sort numbers?
For upcoming training course dates see: Pricing & availability
RE: Sorting lists of words
Hi Chris
Thanks for your question.
The answer is yes, you can sort text.
You need to make sure that the column you want to sort by has a heading at the top, and format the heading in bold so Excel recognises it as a heading and not an item in the list.
Then select a cell that contains a piece of text in that column and click either the Sort Ascending or Sort Descending button on the standard toolbar (they have the letters A and Z on them).
Amanda
|