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

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.