Solved

[excel]How do you arrange names in alphabetical order

Posted on 1998-10-22
2
1,757 Views
Last Modified: 2008-03-17
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
Comment
Question by:steath_acid
2 Comments
 
LVL 1

Accepted Solution

by:
jow earned 30 total points
ID: 1614123
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
 

Author Comment

by:steath_acid
ID: 1614124
Thanks I thought I tried but I guess not.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now