Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Sorting lists of words
Resolved · Low Priority · Version Standard
Chris has attended:
PowerPoint Intermediate Advanced course
Is it possible to sort a list of words in the way you can sort numbers?
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 keyboardCTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal |
We'll call during UK business hours
Server loaded in 0.08 secs.