Contextures

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. go to top

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. go to top

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

Get All the Excel News

For regular Excel news, tips, videos, and special offers, sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search Contextures Sites

 

Excel Tools Add-in

 

 

 

Excel Data Entry Popup List

 

Last updated: January 30, 2017 3:04 PM
Contextures RSS Feed