Select basic ads. Create a personalised ads profile. Select personalised ads. Apply market research to generate audience insights. Measure content performance. Develop and improve products. List of Partners vendors. Tricia Goss. She's written tips and tutorials for Microsoft Office applications and other sites. Facebook Twitter LinkedIn.
Updated on February 04, Tweet Share Email. Was this page helpful? Thanks for letting us know! Email Address Sign up There was an error. Please try once. It allows selecting just one column to be sorted, it manages your table headers, and additionally, it may sort your data on the basis of text font or color. Follow below steps to utilize this technique as I have used in the example given below:.
Here in the example I have selected A to Z. Done Successfully! Those are the basics methods on how to alphabetize and sort by values in Excel. November 2, Share this post. How to Create Table Relationships in Excel? November 9, November 7, All rights reserved. Microsoft Excel. Data Science. Microsoft Office. Digital Marketing.
When using the Sort dialog box, make sure the My data has headers checkbox is selected. Microsoft Excel provides a variety of features to cope with many different tasks. Many, but not all. If you are facing a challenge for which there is no built-in solution, chances are it can be accomplished with a formula. It is also true for alphabetical sorting.
Below, you will find a couple of examples when alphabetical order can only be done with formulas. Since there are a few common ways to write names in English, you may sometimes find yourself in a situation when the entries start with the first name while you need to alphabetize them by the last name:. With a full name in A2, insert the following formulas in two different cells, and then copy them down the columns until the last cell with data:.
The detailed explanation of the formulas can be found here , for now let's just focus on the results:. Since we need to alphabetize the names, not formulas, convert them to values. Right-click the selected cells, click on Values under Paste Options , and press the Enter key:. Good, you are almost there! Now, select any cell in the resulting column, click the A to Z or Z to A button on the Data tab, and there you have it - a list alphabetized by the last name:.
In case you need to revert to the original First Name Last Name format, there is a little more work for you to do:. Split the names into two parts again by using the below formulas where E2 is a comma-separated name :. The process may look a bit complex on paper, but trust me, it will take only a few minutes in your Excel. In fact, it will take even less time than reading this tutorial, let alone alphabetizing the names manually :.
In one of the previous examples we discussed how to alphabetize rows in Excel by using the Sort dialog box. In that example, we were dealing with a correlated set of data.
But what if each row contains independent information? How do you alphabetize each row individually? In case you have a reasonable number of rows, you can sort them one by one performing these steps. If you have hundreds or thousands of rows, that would be an enormous waste of time. Formulas can do the same thing much faster. To begin with, copy the row labels to another worksheet or another location in the same sheet, and then use the following array formula to put each row in alphabetical order where B2:D2 is the first row in the source table :.
If you are not very comfortable with Excel array formulas, please following these steps to enter it correctly in your worksheet:.
0コメント