| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to sort non-alphabetically
Hi there,
Is it possible to sort a list in a certain way not alphabetical. I have a column with entries for towns and I want certain towns at the top for example, Windsor, London then Applegate. Any help would be greatly appreciated Thanks Suzanne |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to sort non-alphabetically
Create a Custom List of the towns (Tools/Options/Custom Lists). Choose
Data/Sort, click Options, and choose your custom list to sort on. In article , Grd wrote: Hi there, Is it possible to sort a list in a certain way not alphabetical. I have a column with entries for towns and I want certain towns at the top for example, Windsor, London then Applegate. Any help would be greatly appreciated Thanks Suzanne |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to sort non-alphabetically
Awesome
Tx very much S "JE McGimpsey" wrote: Create a Custom List of the towns (Tools/Options/Custom Lists). Choose Data/Sort, click Options, and choose your custom list to sort on. In article , Grd wrote: Hi there, Is it possible to sort a list in a certain way not alphabetical. I have a column with entries for towns and I want certain towns at the top for example, Windsor, London then Applegate. Any help would be greatly appreciated Thanks Suzanne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort sheets alphabetically | New Users to Excel | |||
| How do I sort alphabetically in Excel | Excel Discussion (Misc queries) | |||
| How do I sort in Excel alphabetically? | Excel Discussion (Misc queries) | |||
| How do I sort a column alphabetically not consider "the" or "a"? | Excel Discussion (Misc queries) | |||
| sort by alphabetically | New Users to Excel | |||
Linear Mode
