Tips, Tricks, and Answers

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

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.