[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1774
  • Last Modified:

[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
0
steath_acid
Asked:
steath_acid
1 Solution
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now