Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to alphabetize my created list?
I an not very computer literate so I will need step by step instructions on
how to create a list, then alphabetize it. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Depending on how many columns you have this is actually a very easy task.
I'll do a quick example you can try then you can elaborate on it for your own. Type "Adam" - press return - Highlighted cell moves down a row Type" Eve" - press return again and highlighted cell moves down again Type " Alan" Use your mouse to click on any of the typed cells making sure the cursor is flashing and the whole word is not highlighted. There are two buttons on the second row of buttons at the top of the page, one with an A ontop of a Z with and arrow pointing down and one with a Z on top of an A and an arrow pointing down. The A on top will sort alphabetically with Adam then Alan then Eve and the one with Z at the top will do the reverse. Play with this till you get the hang.If you have more than one column just select one cell (cursor flashing only) in the column you want to sort and it will sort the whole table correctly. Hope this helps and isn't too confusing? "etakathy" wrote: I an not very computer literate so I will need step by step instructions on how to create a list, then alphabetize it. Any help would be greatly appreciated. |
#3
|
|||
|
|||
Thank you, it worked and I appreciate the time you took to explain this to me.
"DB Queen (Not)" wrote: Depending on how many columns you have this is actually a very easy task. I'll do a quick example you can try then you can elaborate on it for your own. Type "Adam" - press return - Highlighted cell moves down a row Type" Eve" - press return again and highlighted cell moves down again Type " Alan" Use your mouse to click on any of the typed cells making sure the cursor is flashing and the whole word is not highlighted. There are two buttons on the second row of buttons at the top of the page, one with an A ontop of a Z with and arrow pointing down and one with a Z on top of an A and an arrow pointing down. The A on top will sort alphabetically with Adam then Alan then Eve and the one with Z at the top will do the reverse. Play with this till you get the hang.If you have more than one column just select one cell (cursor flashing only) in the column you want to sort and it will sort the whole table correctly. Hope this helps and isn't too confusing? "etakathy" wrote: I an not very computer literate so I will need step by step instructions on how to create a list, then alphabetize it. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I've accidentally created a LIST range. How can I get rid of it?? | Excel Discussion (Misc queries) | |||
add list to newly created menu | Excel Worksheet Functions | |||
How do I remove a "List" once I've created it in 2003 | Excel Discussion (Misc queries) | |||
How do I make the Excel progam alphabetize my client list? | Excel Discussion (Misc queries) | |||
how to alphabetize a list in Excel | Excel Worksheet Functions |