Excel Sorting Videos

Short Excel videos show how to sort in a custom order, how to sort by row, and more sorting tips

Sort 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 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 Sorting Tips page.

Sort With VBA

This video shows you how to set up a worksheet with hidden rectangles, and some 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 VBA page.

More Tutorials and Videos

Sorting Data -- Basics

Sort Data (2003) -- Basics

Sort Data -- VBA

Excel Videos - Index