Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel training - sorting lists words

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Sorting lists of words

excel training - Sorting lists of words

ResolvedVersion Standard

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?

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.