Solved

[excel]How do you arrange names in alphabetical order

Posted on 1998-10-22
2
1,760 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

792 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