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

Don't Miss Our Excel Tips

Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.

Get weekly Excel tips from Debra

 

Search Contextures Sites

 

Get weekly Excel tips from Debra

 

 

Excel Tools Add-in

 

 

 

Excel Data Entry Popup List

 

Last updated: May 16, 2018 10:59 AM
Contextures RSS Feed