[excel]How do you arrange names in alphabetical order

how do you organize name sin Alphabetical order in Excel, and if the last name in sin a1 and the first is in b1 how do i get then to stay attached?? Thanx
steath_acidAsked:
Who is Participating?
 
jowCommented:
First, select the Column A(select whole column), then go to Menu Bar Data -> Sort (do not use the Sorting button in Toolbar), system will then prompt a Sort Warning message, make sure you choose "Expand the selection" and click SORT, then in Sort By section, you should be able to see the Combo Box shown "Column A", select "Ascending" and click OK.

Rgds Jow
0
 
steath_acidAuthor Commented:
Thanks I thought I tried but I guess not.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.