excel training - Sorting lists of words

The UK's most regular instructor-led training courses.
Training information: excel training · Excel courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Sorting lists of words

Chris has attended:
Powerpoint Advanced course

by - delegate Chris [4 posts] (2007 Jul 3 Tue, 16:01) Reply

Is it possible to sort a list of words in the way you can sort numbers?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Sorting lists of words

by - trainer Amanda platinum contributer [968 posts] (2007 Jul 4 Wed, 12:20) Reply

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

· Prepare for your MOS Certification with MS Excel Courses
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Do You Really Need Excel VBA Training?
· Excel Macros for the Non-Programmer