Search Contextures Sites ![]()
Excel Video Tutorials -- Sorting
Excel Sort in Custom Order
Excel Sort Data by Row
Sort With Excel VBASort in a Custom Order
In addition to the standard sorting options, such as A-Z, you can sort in a custom order. For example, you can sort a column by month order, or create your own custom order list.
In this video, you'll see how to create a custom list, and use it for sorting a column.
For detailed instructions visit the Excel Sorting Tips page.
Sorting a Row
Instead of sorting worksheet data by the values in a column, you can sort the data by row. In this video, you'll see how to sort a table of monthly sales, so the month with the largest sales total is at the left.
For detailed instructions visit the Excel Sorting Tips page.
Sort With Excel VBA
This Excel tutorial video shows you how to set up a worksheet with hidden rectangles, and some Excel VBA code. After that one-time job, just click on a heading, to run the Sort Table macro.
For detailed instructions and the sample code, please visit the Sort With Excel VBA page.
Excel Sort Data Tutorials
1. Excel Sorting Data -- Basics
2. Excel Sort Data (2003) -- Basics
3. Excel Sort Data -- VBA
4. Excel Sort Add-in -- Excel Special Sort
Contextures Inc., Copyright ©2012
All rights reserved.