Search Contextures Sites
Custom Search

 

Related Pages

Sorting Data -- Basics

Sort Data (2003) -- Basics

Sort Data -- VBA

Excel Videos - Index

 

 

 

Excel Video Tutorials -- Sorting

How to sort in a custom order, how to sort by row, and more sorting tips in these short videos.

Sort in Custom Order

Sort Data by Row

Sort With VBA

Sort Data Tutorials

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

Get All the Excel News

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

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.