When an ordinary alphabetical or numerical sort in Microsoft Excel does not work, review the advanced sorting options or add a custom sort pattern.
Excel has several advanced classification options, but most of us never venture beyond ordinary alphabetic and numeric types. If you need more than a simple classification, see the advanced classification options in Excel. In this article, we will discuss several advanced options. Then, I will show you how to create a custom classification for those times when even the advanced settings are not suitable.
I am using Office 365 on a Windows 10 64-bit system, but you can apply these sorting techniques to earlier versions. Custom types are not compatible with the browser edition. You can use your own data or download the demo files .xlsx and .xls.
MORE INFORMATION: Prices and features of Office 365 Consumer
How to use the advanced sorting options in Excel
Once you've mastered the simple, alpha and numeric types, you might want to see the Advanced Sorting Options. You may never need them, but if you do, they are invaluable.
To find these options, click on the Data tab and then click on the Sort option in the Sort and filter group. Then, click on the Options button to start the dialog shown in Figure A . (You must select a range of values to access this setting).
Every time I have a patr With a rating that is not compatible with the built-in features, consider creating a custom l is sort by
Send me your question about Office
I answer readers' questions when I can, but there's no guarantee. Do not send files unless requested; Initial requests for help arriving with attachments will be deleted without reading. You can send screenshots of your data to help clarify your question. When contacting me, be as specific as possible. For example, "Please solve the problems in my workbook and fix what is wrong" you probably won't receive an answer, but "Can you tell me why this formula does not return the expected results? Could you. Mention the application and the version you are using TechRepublic does not reimburse me for my time or experience helping readers, nor do I request a fee from the readers I help. You can contact me at [email protected]
Microsoft weekly newsletter
Be the Microsoft connoisseur of your company with the help of these Windows and Office tutorials and our expert Microsoft business product analysis .
Delivered on Mondays and Wednesdays
Please Note: This content is provided and hosted by a 3rd party server. Sometimes these servers may include advertisements. igetintopc.com does not host or upload this material and is not responsible for the content.