excel training - sorting lists words

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

excel training - Sorting lists of words

resolvedResolved · Low Priority · Version 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:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips


Server loaded in 0.08 secs.