Sorting

Tips, Tricks, and Answers

The following articles are available for the 'Sorting' topic. Click the article's title (shown in bold) to see the associated article.

Sorting a List
Need to sort all the data in a table? Here's the fastest and easiest way to do it.

Sorting Graphics with Worksheet Data
If you use graphics in a worksheet that are associated with certain cells (perhaps images of parts or icons for worksheet entries), you'll be glad to know that when you sort your worksheet data you can have Excel reorder the graphics as well. This tip highlights the factors you need to consider when you want to do this type of sorting.

Sorting in a Protected Worksheet
Protect a worksheet and you might find that you can't do some of the worksheet operations you would like to do. If you want to sort the data in a protected worksheet, you need to inform Excel that you specifically want to allow it.

Specifying a Multi-Level Sort
One way you can easily work with data in a worksheet is to sort it into whatever order you find most helpful. Excel allows you to perform sorting based on the criteria you determine, as discussed in this tip.